During phone screen: "What does GROUP BY do in SQL?"
Utilisateur anonyme
Provides a row of data only for each unique value in the grouped column. You can provide aggregation functions for the other columns, such as SUM or COUNT in order to get meaningful data for those.