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.