Question · SQL and MySQL course · Module 6: Aggregation and grouping
Grouping by multiple columns
What does GROUP BY kategoria_id, rok_wydania do?
Answer options
- It groups only by the first column and ignores the second
- It creates a separate group for each unique pair (category, publication year)
- It sorts the result by two columns
- It joins two tables
You can check the correct answer by solving this task in the CodeWorlds game.