Capital One
Medium
Data ScientistMerge four CSVs locally, robustly and efficiently
Data Manipulation (SQL/Python)
1
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
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
Capital One
Medium
Data ScientistWrite SQL to find top net-revenue products
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Thumbtack
Medium
Data ScientistCompare list/dict; parse JSON/CSV at scale
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Netflix
Medium
Data ScientistWrite SQL for DAU and first-purchase conversion
Data Manipulation (SQL/Python)
1
0
October 13, 2025
TikTok
Medium
Data ScientistCalculate valid daily usage with gap constraints
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Adobe
Medium
Software EngineerImplement scalable word count locally
Data Manipulation (SQL/Python)
0
0
September 6, 2025
OPPO
Medium
Data EngineerSolve three SQL problems (easy/medium/hard)
Data Manipulation (SQL/Python)
0
0
August 14, 2025
Meta
Easy
Data ScientistCompute invalid event percentage by pixel
Data Manipulation (SQL/Python)
0
1
August 1, 2025
Amazon
Medium
Business Intelligence EngineerIdentify Customers Purchasing Every Product in Catalog
Data Manipulation (SQL/Python)
4
0
July 12, 2025
Chime
Easy
Data ScientistCompute early signals for user retention
Data Manipulation (SQL/Python)
1
0
November 6, 2025
Pinterest
Medium
Data ScientistCompute CTR by pin_format and date
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistMerge CSVs and build revenue pivot with pandas
Data Manipulation (SQL/Python)
1
0
October 13, 2025
OneMain Financial
Medium
Data ScientistWrite SQL for cohort retention and ARPU
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistDefine and compute shop visibility in SQL
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Meta
Medium
Data ScientistCompute unread and multi-account user percentages
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Intuit
Medium
Data ScientistCompute paid subscriber YoY counts by month
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Motive
Medium
Software EngineerFetch and process JSON from REST API
Data Manipulation (SQL/Python)
1
0
September 6, 2025
Meta
Medium
Data EngineerWrite SQL for library analytics
Data Manipulation (SQL/Python)
0
0
July 16, 2025
Meta
Medium
Data ScientistCompute daily post success rate for last 7 days
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Airbnb
Medium
Data ScientistCompute browsing metrics in Python from logs
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.