Bloomberg
Medium
Data EngineerWrite PostgreSQL string-manipulation query
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
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
NVIDIA
Medium
Software EngineerParse a deeply nested JSON
Data Manipulation (SQL/Python)
0
0
August 7, 2025
PayPal
Medium
Data ScientistWrite conditional aggregates with CASE WHEN
Data Manipulation (SQL/Python)
1
0
July 31, 2025
Amazon
Medium
Business Intelligence EngineerAnalyze Seller Compliance and Customer Purchase Patterns
Data Manipulation (SQL/Python)
3
0
July 12, 2025
Amazon
Medium
Business Intelligence EngineerFind Top Three Books by City in Recent Months
Data Manipulation (SQL/Python)
3
0
July 12, 2025
Waymo
Easy
Data ScientistMerge overlapping intervals per group in pandas
Data Manipulation (SQL/Python)
0
0
January 17, 2026
Amazon
Medium
Data ScientistFind daily first-order merchants with SQL
Data Manipulation (SQL/Python)
0
2
October 13, 2025
Other
Medium
Data ScientistSolve window-function SQL without joins
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Instacart
Medium
Data ScientistWrite SQL to rank advertisers and profitability
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistBuild DiD dataset with SQL
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
Meta
Medium
Data EngineerSolve library SQL and Python tasks
Data Manipulation (SQL/Python)
0
2
September 6, 2025
Meta
Medium
Data EngineerFind customer with max rentals in consecutive weeks
Data Manipulation (SQL/Python)
0
2
September 6, 2025
Akuna Capital
Medium
Software EngineerIdentify false MySQL foreign key statement
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Coinbase
Medium
Software EngineerCompute delivery metrics and top-K queries
Data Manipulation (SQL/Python)
0
0
July 31, 2025
Amazon
Medium
Business Intelligence EngineerIdentify Unique Unordered City Pairs in Flight Log
Data Manipulation (SQL/Python)
3
0
July 12, 2025
Amazon
Medium
Business Intelligence EngineerCalculate Weekly Event Sums from Daily Counts
Data Manipulation (SQL/Python)
2
0
July 12, 2025
Meta
Medium
Data ScientistAnalyze Hashtag Follow Behavior with SQL Queries
Data Manipulation (SQL/Python)
3
0
July 12, 2025
Databricks
Easy
Data ScientistFind top-5 most similar rows across datasets
Data Manipulation (SQL/Python)
0
0
December 11, 2025
Amazon
Easy
Data ScientistFind recommended friend pairs by shared listening
Data Manipulation (SQL/Python)
0
0
November 20, 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.