Airbnb
Medium
Data ScientistCompute C/T metrics from bookings and visits
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
ByteDance
Medium
Data ScientistWrite SQL for geo posting-frequency drops
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL to compute shop visibility share
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
OpenAI
Medium
Data ScientistDebug and harden trial-assignment Python code
Data Manipulation (SQL/Python)
0
0
October 13, 2025
OpenAI
Medium
Data ScientistWrite SQL for post-trial conversion cohorts
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistImpute missing values without leakage
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
Boston Consulting Group
Medium
Data ScientistQuery top spenders and 7-day growth
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Boston Consulting Group
Medium
Data ScientistManipulate and merge DataFrames correctly
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistProduce dating profile funnel report by cohort
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 ScientistCompute callers contacting >3 people last 7 days
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Voleon Group
Medium
Data ScientistLoad and visualize large CSV robustly
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Robinhood
Medium
Data ScientistWrite SQL to localize trading drop contributors
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for 7-day WhatsApp call metrics
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.