OneMain Financial
Medium
Data ScientistWrite SQL for cohort retention and ARPU
Data Manipulation (SQL/Python)
0
0
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.
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
Block (Square)
Medium
Data ScientistWrite left-join queries with tricky filters
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite dating profile report with final reviews
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Other
Medium
Data ScientistSolve window-function SQL without joins
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Apple
Medium
Data ScientistDetect sessions and gaps using SQL LEAD
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistIdentify country with highest sunny-day probability
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL filtering, grouping, CASE, UNION tasks
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Amazon
Medium
Data ScientistDiagnose MySQL joins and GROUP BY/HAVING errors
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Fannie Mae
Medium
Data ScientistAssess SQL joins, unions, windows, dedup, and pandas
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Lyft
Medium
Data ScientistQuery and transform marketplace data in SQL/Python
Data Manipulation (SQL/Python)
0
0
October 13, 2025
ByteDance
Medium
Data ScientistSelect max-discount product per category
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Point72
Medium
Data ScientistWrite SQL for top student per department
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Point72
Medium
Data ScientistConvert integer dates to quarters
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Fetch Rewards
Medium
Data ScientistWrite SQL to verify quarterly sales decline
Data Manipulation (SQL/Python)
0
0
October 13, 2025
SIG (Susquehanna)
Medium
Data ScientistWrite SQL for deliveries analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Two Sigma
Medium
Data ScientistAnalyze NYC taxi trips efficiently over last 7 days
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
Netflix
Medium
Data ScientistAggregate D1 retention cohorts in SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Citadel
Medium
Data ScientistImplement left join on Python lists, no packages
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Roku
Medium
Data ScientistWrite SQL for profit, growth, retention
Data Manipulation (SQL/Python)
0
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.