Amazon
Medium
Data ScientistDesign idempotent daily loads with deduping
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
96Companies
Easy 31 • Medium 539 • 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
Block (Square)
Medium
Data ScientistWrite left-join queries with tricky filters
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite dating profile report with final reviews
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Gemini
Medium
Data ScientistWrite SQL/Python for ACH fraud analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute cohort GMV and payer rate with edge cases
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
Snowflake
Medium
Data ScientistQuery seven-day conversion with windows and dedupe
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Upstart
Medium
Data ScientistWrite monthly touches and last-touch SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
TikTok
Medium
Data ScientistWrite SQL for last-7-day metrics without windows
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Boston Consulting Group
Medium
Data ScientistTransform and aggregate messy event data
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Software EngineerSet up a Python interview environment
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Google
Medium
Machine Learning EngineerImplement a robust Python generator
Data Manipulation (SQL/Python)
0
0
September 6, 2025
NVIDIA
Medium
Software EngineerImplement a Python test harness
Data Manipulation (SQL/Python)
0
0
August 9, 2025
Meta
Medium
Data EngineerAggregate Netflix metrics in SQL
Data Manipulation (SQL/Python)
1
1
August 4, 2025
Meta
Medium
Data ScientistAnalyze Seller Activity and Vehicle Listing Interactions
Data Manipulation (SQL/Python)
0
0
August 4, 2025
Meta
Medium
Data EngineerWrite SQL and Python for data prep
Data Manipulation (SQL/Python)
1
1
July 15, 2025
Databricks
Easy
Data ScientistCount weekly customers with ≥$1000 YTD spend
Data Manipulation (SQL/Python)
0
0
December 3, 2025
TikTok
Easy
Data ScientistFind top-paid employee per department
Data Manipulation (SQL/Python)
0
0
November 8, 2025
PayPal
Easy
Data ScientistCompute top orders and cancellation rate
Data Manipulation (SQL/Python)
0
0
November 3, 2025
Capital One
Medium
Data ScientistFind top category per region in Aug 2025
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.