Meta
Medium
Data ScientistIdentify Duplicate Posts by User and Date
Data Manipulation (SQL/Python)
1
0
August 4, 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
PayPal
Medium
Data ScientistCompare WHERE vs HAVING with aggregates
Data Manipulation (SQL/Python)
0
0
July 31, 2025
Instacart
Medium
Software EngineerPivot data without date libraries
Data Manipulation (SQL/Python)
0
0
July 31, 2025
Others
Easy
Data ScientistCompute per-coin quarterly amounts and totals
Data Manipulation (SQL/Python)
0
0
January 17, 2026
Cvs
Easy
Data ScientistCompute specialty spend share and top age band
Data Manipulation (SQL/Python)
0
0
October 17, 2025
Capital One
Medium
Data ScientistIdentify country with highest sunny-day probability
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Coinbase
Medium
Data ScientistCompute adoption, latency, and cross-region transactions
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistLabel new vs old users over time in SQL
Data Manipulation (SQL/Python)
0
1
October 13, 2025
Amazon
Medium
Data ScientistVerify subscriptions and analyze orders with SQL/Python
Data Manipulation (SQL/Python)
0
0
October 13, 2025
TikTok
Medium
Data ScientistWrite SQL for geo posting-frequency drops
Data Manipulation (SQL/Python)
0
0
October 13, 2025
OpenAI
Medium
Data ScientistWrite SQL for post-trial conversion cohorts
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for initiators and French DAU%
Data Manipulation (SQL/Python)
0
1
October 13, 2025
Meta
Medium
Data ScientistDefine and analyze new-vs-existing activity
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Other
Medium
Data ScientistDiagnose zero IE uploads with SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
PayPal
Medium
Data ScientistWrite SQL to flag Venmo ATO
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute feed ad frequency and retention in SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
EY
Medium
Data ScientistArchitect cloud data ingestion patterns
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute view prevalence from views and labels
Data Manipulation (SQL/Python)
0
0
October 13, 2025
TikTok
Easy
Data ScientistWrite SQL for TikTok Live creator metrics
Data Manipulation (SQL/Python)
0
0
October 9, 2025
Microsoft
Medium
Software EngineerCount words in a document robustly
Data Manipulation (SQL/Python)
0
0
August 14, 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.