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

Grouping by two columns

Arrange the clauses of a query grouping by two columns in the correct order (top to bottom):

Items to put in order

  • GROUP BY kategoria_id, rok_wydania
  • SELECT kategoria_id, rok_wydania, COUNT(*)
  • FROM ksiazki

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