I have two tables I want to compare data from. The query of the first table is below and it gives me 12 rows. ***** 1st Query ************ SELECT distinct a.pnr AS PNR, a.station_code as Station,a.date as Date, sum(a.allamount) as…
I've a very big table (around 19.000.000 records), and I want to select 10 rows randomly. I found this solution: select * from my_table as one where one.id >= ( select FLOOR(rand() * (select max(two.id) from my_table as two)) as…
I'm currently working on LeetCode problem 619, "Biggest Single Number," using MySQL. The problem can be found at this link: https://leetcode.com/problems/biggest-single-number/description/ I've written a query for this problem, but I'm unable to obtain the correct answer. I suspect that the…
Given a row in an example table as: Column A abcccaaaaddeeaabbaa How can we get the following output using MYSQL? sequence occurrences aaaa 1 ccc 1 dd 1 ee 1 aa 2 bb 1 a 1 b 1 Tried to…
I have the following code: query = "SELECT * FROM appointments WHERE service IN %s AND location LIKE '%London%'" values = (services,) # services is a tuple of strings. cur.execute(query, values) When I execute this code I get the following…
There is a database with online store customers, which has the following data: id buyer's; order number; date and time of the order; order amount. Data on customers and orders for 3 months. How to withdraw customers who made more…
I have two users: alice and bob. I have one organization: contoso. Alice is member of contoso. What I want is for alice to be able to add bob as member of contoso since alice is member of contoso. I…
I have two tables like this: collection_id added_on edited_on 1 2024-06-19 20:16:41 null 2 2024-06-19 20:17:42 null 3 2024-06-19 20:17:57 null and detail_id collection detail_type detail_value 1 1 title Book title 1 2 1 author John Doe 3 1 publisher…
I have following data in tourament MySQL table. id name team 1 Warren A 2 Carol B 3 Donna 4 William A 5 Andrew C 6 Neil A 7 Max A 8 Phil 9 William 10 Keith 11 Phil I…
I'm working on an application that has an issue in production where one query throws a timeout. The app uses MySQL. SELECT `tags`.*, COUNT( ct.contact_id ) AS contacts_count FROM `tags` LEFT JOIN `contact_tag` AS `ct` ON `tags`.`id` = `ct`.`tag_id` WHERE…