I am trying to query the code, name, and the number of rentals of customers who have made at least ten rentals. My query: Select client.ClientCode, client.ClientNom, (location.LocationRef) FROM client INNER JOIN location ON client.ClientCode = location.ClientCode WHERE location.LocationRef >…
I currently have this JSONs in my database user info 0 ["subscriptions": [{"user": 1}, {"user": 2}]] 1 [] 2 null And I want something like SELECT * FROM user_info WHERE count(subscriptions) == 2 (select by count of elements in "subscriptions"…
SELECT COUNT(*), tanggal as totRits AND COUNT(*), total AS tNote FROM tblsolar WHERE tanggal LIKE '%" & sqlDate & "%' AND supir LIKE '%" & cboSupir & "%' GROUP BY tanggal How do I SELECT the COUNT two times?
I've been strugling today Because am trying to remove all the duplicates but it doesn't work SELECT DISTINCT pays, nom, count(titre) FROM film JOIN personne ON film.idRealisateur = personne.id GROUP BY nom ORDER BY count(titre) DESC LIMIT 10 OUTPUT Even…
I have following query. I need MODEL_YEAR_FW 2003 to 2022 to be grouped 3 years each SELECT COUNT(VEHICLE_FW.MODEL_YEAR_FW) AS COUNT_VEHICLES, VEHICLES_FW.MODEL_YEAR_FW AS MODEL_YR FROM FWUSER.VEHICLES_FW WHERE VEHICLES_FW.ARCHIVE_STATUS_FW - 'N' AND ( (MODEL_YEAR_FW) >2003) GROUP BY VEHICLE_FW.MODEL_YEAR_FW ORDER BY VEHICLES_FW.MODEL_YEAR_FW Someone…
I have a table persons; INSERT INTO `persons` (`tc`, `name`, `surname`, `gender`, `city`, `stret`, `apertment_number`) VALUES What everyone is looking for is the name by which they are questioned, which is the same person to question what happened at the…
I need to get the initial state as well as the latest state from a MySQL database. This is over two tables: customer id name surname dob email telephone 10 Steve Bobbly 01-01-1970 [email protected] 0123456789 15 James Bond 01-01-1950 [email protected]…
I have a query in MariaDB 10.3 database where there is a field called "expiration_date" that stores a unix timestamp, but if there is no data in the field the default is set to "0". I'm trying to use a…
I am trying to come up with a query that will return the aggregate data for the earliest orders the customers have placed. Is it possible to do this when there are multiple rows/orders that were placed on the earliest…
I am joining a few tables and in each join, I have to specify a specific condition. SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id WHERE table2.column1 = 'horse' INNER JOIN table3 ON table2.id = table3.id WHERE…