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.