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.