Im trying to make the next query making use of Kotlin SQL Exposed framework. SELECT interation_id, group_id, max(version) FROM interaction GROUP BY group_id; I have a table of interactions, and each interaction group can have multiple interactions, each one marked…
created_date rake_device rounded_geo_lat rounded_geo_lng idle_or_moving new_idle_moving 08-01-2024 11:27 a-b 28.29 76.39 idle idle 08-01-2024 10:27 a-b 28.29 76.39 idle idle 08-01-2024 09:27 a-b 28.29 76.39 idle idle 08-01-2024 08:27 a-b 28.29 76.39 idle idle 08-01-2024 07:27 a-b 28.29 76.39 idle…
I have two queries that I’m trying to combine, but I’m having an issue and I believe it has to do with the GROUP BY Date when I do LEFT JOIN. The date formats are the same and the only…
I'm trying to validate the users logged in based on month. SQL current df user id date P1302 2023-11-01 P1302 2023-10-01 P1302 2023-09-01 P1302 2023-08-01 P1302 2023-07-01 P1302 2023-06-01 P1301 2023-11-01 P1301 2023-10-01 P1301 2023-08-01 P1301 2023-07-01 P1301 2023-06-01 expected…
I have table with 5 million rows. Example +----+-----------+---------+------- | product | date | count | +-------------+------------+-----------+ | платье | 04-01-2024 | 186574 | | штаны | 04-01-2024 | 20564 | | кепка | 07-01-2024 | 104443 | | штаны…
The situation is this: I have two columns in my database. User Parent Amy K. Theo K. Lena K. Theo K. Jiha L. John L. John L. Victor L. Theo K. Simba K. Simba K. Ellen K. Now I need…
I'm looking to sort multiple tables that are in a database based on the last time the table was updated. The tables all have a column called Update_Time that updates the timestamp when that row is updated in the table.…
I have a service in which customers can open a "customer service ticket" which is charged. Whenever they do, they can open how many more "customer service tickets" they want for the next 30 days without being charged; and after…
I try to update my base SellAll with the value of a previous stock. I have this request so far : UPDATE SellAll set S_stock = (S_in - S_out) + monthn1.stock FROM ( SELECT LAG(S_stock,1,0) OVER (ORDER BY S_famille,S_year, S_month)…
I have this majors table id name group score 1 Computer Science A 688 2 Electrical Engineering B 647 3 Psychology A 616 (more data on the link below) And this tests table id group score 1 B 690 2…