Shopify
Easy
Data ScientistCompute pirated-theme usage and revenue loss
Data Manipulation (SQL/Python)
2
0
January 17, 2026
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
Amazon
Medium
Business Intelligence EngineerAnalyze Top Book Sales and Unique Customer Purchases
Data Manipulation (SQL/Python)
8
0
July 12, 2025
Pinterest
Easy
Data ScientistWrite SQL for top categories and highly active users
Data Manipulation (SQL/Python)
2
0
December 5, 2025
Meta
Medium
Data EngineerTackle Python tasks under time pressure
Data Manipulation (SQL/Python)
2
0
September 6, 2025
Lyft
Medium
Software EngineerPrint the K-th non-empty line
Data Manipulation (SQL/Python)
2
0
September 6, 2025
Uber
Medium
Data ScientistWrite SQL for fares and age-band counts
Data Manipulation (SQL/Python)
3
1
October 13, 2025
Meta
Medium
Data ScientistDetermine Product Buyer Count and Interaction Percentage
Data Manipulation (SQL/Python)
9
0
July 12, 2025
LinkedIn
Medium
Data Scientist[SQL] Job Ad Metrics with Applicant Filter
Data Manipulation (SQL/Python)
9
0
April 23, 2025
Google
Medium
Data ScientistAnalyze video flags and reviews with SQL
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Airbnb
Medium
Data ScientistCompute C/T metrics from bookings and visits
Data Manipulation (SQL/Python)
2
0
October 13, 2025
DoorDash
Medium
Data ScientistMeasure Late Deliveries and Identify Top Delayed Restaurants
Data Manipulation (SQL/Python)
3
1
August 4, 2025
Snapchat
Medium
Data ScientistCompute CTR and metrics with pandas
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Meta
Medium
Data EngineerRecommend two-hop follows in Python
Data Manipulation (SQL/Python)
0
0
August 1, 2025
Coinbase
Medium
Data ScientistCalculate Cumulative Sum for Each Integer in Table
Data Manipulation (SQL/Python)
12
0
July 12, 2025
Meta
Easy
Data ScientistCompute active ad revenue by creation source
Data Manipulation (SQL/Python)
0
0
December 6, 2025
TikTok
Easy
Data ScientistWrite monthly customer and sales SQL queries
Data Manipulation (SQL/Python)
2
0
November 27, 2025
OpenAI
Medium
Data ScientistDebug and harden trial-assignment Python code
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Millennium Management
Medium
Software EngineerImplement paginated API ingestion
Data Manipulation (SQL/Python)
1
0
September 6, 2025
Newyorktimes
Easy
Data AnalystWrite SQL for content-view analytics
Data Manipulation (SQL/Python)
0
0
January 17, 2026
Roku
Medium
Data ScientistWrite SQL for profit, growth, retention
Data Manipulation (SQL/Python)
2
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.