DoorDash
Medium
Data ScientistWrite SQL for percent and window changes
Data Manipulation (SQL/Python)
0
0
October 13, 2025
SQL Aggregation Interview Questions
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.
148Questions
39Companies
Common SQL aggregation interview patterns
- Choosing the correct grouping level
- HAVING vs WHERE for post-aggregation filters
- Conditional aggregation with CASE
- COUNT(DISTINCT) vs COUNT
- Aggregation after joins
- Top N per group with aggregation
SQL aggregation interview questions
Filter and sort
CVS Health
Medium
Data ScientistCreate and query an e-commerce schema
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistWrite SQL to find top net-revenue products
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Uber
Medium
Data ScientistWrite SQL for active counts and YTD top driver
Data Manipulation (SQL/Python)
0
0
October 13, 2025
ByteDance
Medium
Data ScientistWrite SQL for 7-day geo-localized revenue dashboard
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute daily post success rate for last 7 days
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Flatiron Health
Medium
Data ScientistWrite SQL window functions for streaks
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Chime
Medium
Data ScientistWrite rolling-window SQL over weekly cohorts
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL with HAVING and efficient joins
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Stripe
Medium
Data ScientistWrite SQL to detect recurring non-subscription users
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistMerge seven tables into one clean DataFrame
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Boston Consulting Group
Medium
Data ScientistUnify 7 tables and impute missing values
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute French DAU video-call percentage yesterday
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for revenue and advertiser analyses
Data Manipulation (SQL/Python)
0
0
October 13, 2025
CVS Health
Medium
Data ScientistUse pandas to aggregate, pivot, and label
Data Manipulation (SQL/Python)
0
0
October 13, 2025
CVS Health
Medium
Data ScientistWrite SQL for dedup and purchase shares
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Snowflake
Medium
Data ScientistBuild a cohort dashboard with Streamlit and SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Snowflake
Medium
Data ScientistQuery seven-day conversion with windows and dedupe
Data Manipulation (SQL/Python)
0
0
October 13, 2025
TikTok
Medium
Data ScientistCompare SQL counts, windows, and NULL semantics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite advanced SQL for sales support analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Common mistakes with SQL aggregation
- Grouping by too many columns
- Using WHERE instead of HAVING for aggregates
- Double counting after joins
- COUNT(column) skipping NULLs unintentionally
- Misusing DISTINCT on aggregated fields
How aggregation questions are evaluated in interviews
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.