Amazon
Medium
Data ScientistBuild DID panel and compute effects in SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
SQL HAVING Clause Interview Questions
HAVING questions test your ability to filter aggregated data, a critical skill that goes beyond basic GROUP BY.
Expect questions combining GROUP BY, aggregates (SUM, COUNT, AVG), and HAVING conditions.
Interviewers evaluate whether you understand the difference between WHERE and HAVING, and proper ordering of clauses.
571Questions
95Companies
Easy 23 • Medium 7 • Hard 0Difficulty mix
Common SQL HAVING interview patterns
- Filtering groups with HAVING vs filtering rows with WHERE
- HAVING with COUNT, SUM, AVG, and other aggregates
- TOP N per group using HAVING with aggregates
- Multiple conditions in HAVING clauses
- HAVING with complex aggregate expressions
- Combining GROUP BY, WHERE, and HAVING in the correct order
SQL HAVING clause interview questions
Filter and sort
Boston Consulting Group
Medium
Data ScientistTransform and aggregate messy event data
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Amazon
Medium
Data ScientistProcess real-time enter/exit events and actives
Data Manipulation (SQL/Python)
0
0
October 13, 2025
PayPal
Medium
Data ScientistWrite SQL to flag Venmo ATO
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for social feed metrics and ties
Data Manipulation (SQL/Python)
0
0
October 13, 2025
DoorDash
Medium
Data ScientistWrite SQL to backtest refund policy
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Pinterest
Medium
Data ScientistWrite SQL to rank categories by impressions
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Airbnb
Medium
Data ScientistBuild panel in SQL; run causal regression
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Roblox
Medium
Data ScientistImplement deduped CTR/RPM aggregator over event stream
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Roblox
Medium
Data ScientistCompute CTR, RPM, and daily RPM variability in SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Roblox
Medium
Data ScientistWrite SQL for ads metrics and variability
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Roblox
Medium
Data ScientistCompute ARPDAU/ARPPU by country
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Roblox
Medium
Data ScientistWrite SQL to flag suspect payments and chargebacks
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Twitch
Medium
Data ScientistWrite robust SQL for streaming analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistFix dash dates and aggregate watch time
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistWrite one SQL for exam scores aggregation
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute multi-account activity and unread percentages in SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
DoorDash
Medium
Data ScientistWrite complex SQL on DoorDash data
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Intuit
Medium
Data ScientistCompute paid subscriber YoY counts by month
Data Manipulation (SQL/Python)
0
0
October 13, 2025
DoorDash
Medium
Data ScientistSolve multi-part SQL with sliding windows
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Common mistakes with HAVING
- Using WHERE instead of HAVING to filter aggregates
- Incorrect clause ordering (HAVING before GROUP BY)
- Aggregating already-aggregated values in HAVING
- Confusion between row-level filters (WHERE) and group-level filters (HAVING)
- Not considering NULL values in aggregate conditions
How HAVING questions are evaluated in interviews
Understanding the execution order of clauses is key.
Explain why WHERE filters rows but HAVING filters groups.
Demonstrate correct aggregate function usage in filtering contexts.
Related SQL concepts
SQL HAVING Clause Interview FAQs
What is the difference between WHERE and HAVING?
WHERE filters individual rows before aggregation occurs. HAVING filters groups after aggregation. You use WHERE to exclude rows from being aggregated, and HAVING to exclude groups from the final result.
Can you use HAVING without GROUP BY?
Some databases allow it, treating the entire result set as one group. However, this is generally considered non-standard and not recommended. Always pair HAVING with GROUP BY for clarity and portability.