Disney
Medium
Software EngineerImplement Spring MVC to find top-enrolled course
Data Manipulation (SQL/Python)
0
0
September 6, 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
Software EngineerSet up a Python interview environment
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Akuna Capital
Medium
Software EngineerIdentify false MySQL foreign key statement
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Bloomberg
Medium
Data EngineerWrite PostgreSQL string-manipulation query
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Amazon
Medium
Software EngineerCompute unique visitors per department from clicks
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Bloomberg
Medium
Data EngineerWrite Postgres string parsing and aggregation query
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Adobe
Medium
Software EngineerImplement scalable word count locally
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Instacart
Medium
Software EngineerPivot transactions by date without date libs
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Stripe
Medium
Software EngineerCompute costs with validation and sorting in Python
Data Manipulation (SQL/Python)
0
0
September 6, 2025
DoorDash
Medium
Software EngineerCompute dasher pay from deliveries
Data Manipulation (SQL/Python)
0
0
September 6, 2025
MathWorks
Medium
Software EngineerCalculate cost from orders with SQL
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Stripe
Medium
Software EngineerGenerate user notifications from schedules
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Microsoft
Medium
Software EngineerCompute most popular location with weights
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Jane Street
Medium
Software EngineerUse Excel formulas to compute haircuts
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Lyft
Medium
Software EngineerPrint the K-th non-empty line
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Applied Intuition
Medium
Software EngineerImplement a nested object validator
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Airbnb
Medium
Software EngineerReview a geospatial Python module
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Meta
Medium
Data EngineerSolve Python and SQL data tasks
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Tools For Humanity
Easy
Data ScientistCompute reply-based engagement metrics
Data Manipulation (SQL/Python)
0
0
August 29, 2025
Apple
Easy
Data ScientistWrite queries to compute salary and budget stats
Data Manipulation (SQL/Python)
0
0
August 24, 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.