I have this SQL query: SELECT COUNT(DISTINCT CustomerName) over( ORDER BY OrderTimestamp RANGE BETWEEN INTERVAL 2 hour PRECEDING AND CURRENT ROW ) AS count_per_time FROM Orders WHERE CustomerName IS NOT null AND CustomerName != '' but it doesn't work because…
Is there any better way to write this query? { $facet: { results: [ { $match: { $expr: { $and: [{ $gte: ["$var1", 1] }, { $gte: ["$var2", 200] }], }, }, }, { $sort: { var1: 1 } },…
Let's say inside the text file is this information: <Amanda> Hi there, how are you? <Jack> Hi, im fine . . . . <Jack> see you later I want to count the words each user have said the output should…
How to query result as Expect Count with Sqlstatement ID StuId IsDone ExpectCount 11111 q-01 false 1 11111 q-02 false 2 11111 q-03 false 3 11111 q-02 true 2 11111 q-04 false 3 22222 q-04 false 2 11111 q-01 true…
Can anyone help me whats wrong with my code SELECT agent.agent_name AS agent_name, (SELECT COUNT(assigned.id_agent))AS itung, (SELECT COUNT(ticket.id_agent) WHERE ticket.id_status = 4) AS itung2 FROM agent LEFT JOIN assigned ON agent.id = assigned.id_agent LEFT JOIN ticket ON agent.id = ticket.id_agent…
I have a result variable composed of 3 lists : var result = { type: [a,a,b,c,d,a,a,b], program : [P1, P1, P2, P1, P2, P2, P2, P1], reference : [ref1,ref2,ref3,...,ref8]} I want to group my reference by type and program to…
I've made a query to count and rank every row for a table, but I can't join the query into one table. I've been trying to make a leaderboard and I've managed to make a query that ranks every row…
I have created my first MySQL query to get the minimum LTP by MarketName/SelectionName. It works ok but I'm struggling to work out how to get the rest of the fields from the original table (checktable). I just want the…
I have the following table and i am supposed to count the entries(5,4,3,2,1) per column name ID ClientID Responsiveness1 Responsiveness2 Reliability1 1024 3511 5 4 3 1025 4571 5 3 5 1026 3827 4 5 4 1027 7652 1 1…
I have a table similar to the following. (The addresses are actually IP addresses, but I'm keeping them short for simplicity.) | Cust ID | Address | | ------- | --------| | 1 | 111 | | 1 | 222…