Put in order · SQL and MySQL course · Module 6: Aggregation and grouping
Clauses of a full aggregating query
Arrange the clauses of a full aggregating query in the correct order (top to bottom):
Items to put in order
- WHERE dostepna = 1
- FROM ksiazki
- SELECT kategoria_id, COUNT(*)
- ORDER BY COUNT(*) DESC
- HAVING COUNT(*) > 3
- GROUP BY kategoria_id
You can check the correct answer by solving this task in the CodeWorlds game.