Glean
Medium
Data ScientistSQL: Zero-Filled DAU, Rolling 30-Day MAU, and the MAU Impact of a User-ID Rehash
Data Manipulation (SQL/Python)
7
2
September 30, 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.