Put in order · SQL and MySQL course · Module 6: Aggregation and grouping

Grouping with a HAVING filter

Arrange the clauses of a grouping query with a group filter in the correct order (top to bottom):

Items to put in order

  • HAVING COUNT(*) > 3
  • GROUP BY kategoria_id
  • SELECT kategoria_id, COUNT(*)
  • FROM ksiazki

You can check the correct answer by solving this task in the CodeWorlds game.