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.