Intermediate
SQL
Q58 / 100
What does "GROUP BY" require regarding columns in the SELECT list (in standard SQL)?
Correct! Well done.
Incorrect.
The correct answer is B) Every selected column must either be part of the GROUP BY clause or wrapped in an aggregate function
B
Correct Answer
Every selected column must either be part of the GROUP BY clause or wrapped in an aggregate function
Explanation
In standard SQL, non-aggregated columns in the SELECT clause must appear in the GROUP BY clause; otherwise their value would be ambiguous across multiple rows in the same group.
Progress
58/100