Uber
Medium
Data ScientistWrite SQL for fares and age-band counts
Data Manipulation (SQL/Python)
6
1
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.
635Questions
102Companies
Easy 52 • Medium 539 • Hard 7Difficulty 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
Easy
Data ScientistConvert multi-currency revenue to USD totals
Data Manipulation (SQL/Python)
8
0
February 16, 2026
DoorDash
Medium
Data ScientistMeasure Late Deliveries and Identify Top Delayed Restaurants
Data Manipulation (SQL/Python)
6
1
August 4, 2025
Glean
Easy
Data ScientistCompute DAU and rolling MAU with zero days
Data Manipulation (SQL/Python)
6
0
November 10, 2025
Netflix
Medium
Data ScientistWrite SQL for DAU and first-purchase conversion
Data Manipulation (SQL/Python)
6
0
October 13, 2025
Meta
Medium
Data ScientistCompute multi-account actives and unread coverage
Data Manipulation (SQL/Python)
7
0
October 13, 2025
DoorDash
Medium
Data ScientistFind orders from bottom-quartile revenue restaurants
Data Manipulation (SQL/Python)
6
0
July 7, 2025
Netflix
Medium
Data ScientistAggregate D1 retention cohorts in SQL
Data Manipulation (SQL/Python)
5
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL to compute shop visibility share
Data Manipulation (SQL/Python)
6
0
October 13, 2025
Lyft
Medium
Software EngineerPrint the K-th non-empty line
Data Manipulation (SQL/Python)
5
0
September 6, 2025
Netflix
Medium
Machine Learning EngineerTransform flat keys into nested dictionary
Data Manipulation (SQL/Python)
6
0
August 13, 2025
Meta
Medium
Data ScientistWrite SQL for CTR and Revenue
Data Manipulation (SQL/Python)
6
0
March 12, 2026
Meta
Medium
Data ScientistFind posts with >60s unconnected viewing time
Data Manipulation (SQL/Python)
5
1
July 28, 2025
Amazon
Medium
Business Intelligence EngineerIdentify Top-Buying Customers Daily with SQL Query
Data Manipulation (SQL/Python)
14
0
July 12, 2025
Reddit
Medium
Data ScientistQuery US-based users and most active forums
Data Manipulation (SQL/Python)
6
0
September 19, 2025
Meta
Medium
Data ScientistCompute SHOP spend share and model performance
Data Manipulation (SQL/Python)
6
0
August 21, 2025
Bytedance
Hard
Data AnalystFind high-value crypto users and top CTR
Data Manipulation (SQL/Python)
6
0
February 23, 2026
Meta
Easy
Data ScientistCompute multi-account user distribution and unread pct
Data Manipulation (SQL/Python)
7
0
February 3, 2026
DoorDash
Hard
Analytics EngineerCompute Fitness App DAU
Data Manipulation (SQL/Python)
6
0
October 12, 2025
Instacart
Medium
Data ScientistExplain handling very large datasets
Data Manipulation (SQL/Python)
5
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.