Meta
Medium
Data ScientistCompute SHOP spend share and model performance
Data Manipulation (SQL/Python)
0
0
August 21, 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
Meta
Medium
Data ScientistCompute time-spent percentage by app category
Data Manipulation (SQL/Python)
0
0
August 17, 2025
Meta
Medium
Data ScientistFind the most-used app
Data Manipulation (SQL/Python)
0
0
August 17, 2025
OPPO
Medium
Data EngineerSolve three SQL problems (easy/medium/hard)
Data Manipulation (SQL/Python)
0
0
August 14, 2025
Microsoft
Medium
Software EngineerCount words in a document robustly
Data Manipulation (SQL/Python)
0
0
August 14, 2025
Motive
Medium
Software EngineerFetch and parse JSON from REST API
Data Manipulation (SQL/Python)
0
0
August 13, 2025
Meta
Medium
Data EngineerWrite SQL for library analytics
Data Manipulation (SQL/Python)
0
0
August 13, 2025
Netflix
Medium
Machine Learning EngineerTransform flat keys into nested dictionary
Data Manipulation (SQL/Python)
0
0
August 13, 2025
Marshall Wace
Medium
Software EngineerFind users with multi-country successful logins
Data Manipulation (SQL/Python)
0
0
August 13, 2025
Kikoff
Medium
Software EngineerParse CSV and format transactions
Data Manipulation (SQL/Python)
0
0
August 12, 2025
Reevo
Medium
Software EngineerFetch and aggregate paginated team data via API
Data Manipulation (SQL/Python)
0
0
August 12, 2025
Reevo
Medium
Software EngineerCount sports by calendar quarter in SQL
Data Manipulation (SQL/Python)
0
0
August 12, 2025
Tesla
Medium
Machine Learning EngineerCompute nearest index within threshold after walking distances
Data Manipulation (SQL/Python)
0
0
August 12, 2025
OpenAI
Medium
Machine Learning EngineerImplement vectorized NumPy ops and explain broadcasting
Data Manipulation (SQL/Python)
0
0
August 11, 2025
Amazon
Medium
Software EngineerManipulate time-series with Pandas groupby
Data Manipulation (SQL/Python)
0
0
August 10, 2025
NVIDIA
Medium
Software EngineerImplement a Python test harness
Data Manipulation (SQL/Python)
0
0
August 9, 2025
DoorDash
Medium
Software EngineerCompute courier pay with peak-hour rules
Data Manipulation (SQL/Python)
0
0
August 9, 2025
SIG (Susquehanna)
Medium
Software EngineerCalculate minutes between two time strings
Data Manipulation (SQL/Python)
0
0
August 8, 2025
Citadel
Medium
Data ScientistPerform EDA and diagnose data quality
Data Manipulation (SQL/Python)
0
0
August 8, 2025
Coinbase
Medium
Software EngineerImplement filtered transactions with cursor pagination
Data Manipulation (SQL/Python)
0
0
August 8, 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.