Google
Easy
Business Intelligence EngineerQuick-Fire SQL and Python Fundamentals: GROUP BY, JOINs, HAVING, Lists vs Tuples
Data Manipulation (SQL/Python)
1
0
November 2, 2026
Aggregation questions test whether you can summarize data at the right grain using GROUP BY and HAVING.
Common themes include COUNT vs COUNT(DISTINCT), conditional aggregation with CASE, and aggregating after joins.
Interviewers look for correct groupings, handling of NULLs, and clear explanation of your logic.
Correct grouping and filtering matter more than micro-optimizations.
Explain your grain, especially when combining joins and aggregates.
Call out assumptions about NULLs and duplicates.