Question · SQL and MySQL course · Module 6: Aggregation and grouping
SELECT and GROUP BY
Which columns may appear in the SELECT list when using GROUP BY?
Answer options
- Any columns from the table, with no restrictions
- Only the columns listed in GROUP BY and aggregate functions
- Only the primary key id
- Only text columns
You can check the correct answer by solving this task in the CodeWorlds game.