example table data: id | name | tool ——————– 1 | bob | scissor 2 | mike | knife 3 | john | thread 4 | joe | ruler 5 | kim | marker 6 | dean | board 7 | paul | knife 8 | john | scissor 9 | kim | ruler 10|… Read More get table results by top 5 of most common table data

Solution problem SELECT agency_name, Count(*) AS complaint_type_count FROM service_request_xs GROUP BY agency_name ORDER BY Count(*) DESC; solution uploaded >Solution : You have to tell the count() function what to count. You can insert an individual column, or * for all of it etc. But you have to count something. This is a fiddle, showing how… Read More SQL Query, What have I done wrong? I am fairly new to mySQL

I have two tables one is called Shelf Table which has the Shelf Number SEQ SHELF_NUMBER QUANTITY 1 ID001 100 2 ID002 20 3 ID003 55 4 ID004 200 5 ID005 38 And the Other Table that i have is Shelf_Data SEQ SHELF_NUMBER_FK FIELD VALUE 1 ID001 BATCH 100006 2 ID001 SHELF_DATE 08/20/2023 3 ID002… Read More Order By Clause not working in SQL Server for Sorting date value

I have a problem with the following task from the platform Codesignal: After some investigation, you’ve created a database containing a foreignCompetitors table, which has the following structure: competitor: the name of the competitor; country: the country in which the competitor is operating. In your report, you need to include the number of competitors per… Read More How do I order countries by name in SQL?

I was testing some apparently wrong code and was quite sure it should return a syntax error. But it didn’t. The following query works without errors (albeit doesn’t sort the table either, which at least meets my expectations): SELECT * FROM dummy ORDER BY ‘id’ ‘desc’; Interestingly, that SELECT * FROM dummy ORDER BY id… Read More Why doesn't ORDER BY 'id' 'desc' return a syntax error?

I have a database where some forecasts for two locations are stored. For every location there are forecasts for 3 days and for every day there are multiple forecasts every hour. I want to select the latest forecast for each location for every day. The location is saved as "location", each day is saved as… Read More How to select a row for every location for every day using SQL?

As i said in the title i have problems sorting my data in the correct order. I have tried a few different combinations but they all return the data in the wrong manner. The date column is in datetime format A few codes that i have tried : SELECT CONVERT(VARCHAR(10), recievedDate, 104) as day FROM… Read More SQL ORDER BY DATETIME 'dd.MM.yyy' problem