HBO
Medium
Data ScientistWrite SQL for streaming cohort metrics
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
Microsoft
Medium
Data ScientistQuery email logs for deliverability insights
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Pinterest
Medium
Data ScientistAggregate video time and unique pins in Python
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Pinterest
Medium
Data ScientistCompute CTR by format for new US users
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Freddie Mac
Medium
Data ScientistAssess SQL cleaning, mapping, joins, keys, and DDL/DML
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Tubi
Medium
Data ScientistCompute daily net users from event logs
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Yahoo
Medium
Data ScientistUse OrderedDict to dedupe stably
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Yahoo
Medium
Data ScientistDiagnose DAU drop with SQL by country
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
Microsoft
Medium
Data ScientistFind common friends from directed edges
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Netflix
Medium
Data ScientistWrite SQL for rolling frequency caps
Data Manipulation (SQL/Python)
0
0
October 13, 2025
ByteDance
Easy
Data ScientistWrite SQL for TikTok Live creator metrics
Data Manipulation (SQL/Python)
0
0
October 9, 2025
OpenAI
Easy
Data ScientistCompute signup rate and retention from raw logs
Data Manipulation (SQL/Python)
0
0
October 4, 2025
IBM
Easy
Data ScientistWrite SQL to compute max and min marks
Data Manipulation (SQL/Python)
0
0
October 3, 2025
Reddit
Medium
Data ScientistQuery US-based users and most active forums
Data Manipulation (SQL/Python)
0
0
September 19, 2025
Character
Medium
Data ScientistWrite SQL for character safety and engagement metrics
Data Manipulation (SQL/Python)
0
0
September 13, 2025
Coinbase
Medium
Software EngineerImplement filters and cursor pagination
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Aeonea
Medium
Software EngineerFill missing values with means
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Bilt Rewards
Medium
Software EngineerWrite SQL to Join Merchants and Triple Restaurant Points
Data Manipulation (SQL/Python)
0
0
September 6, 2025
TikTok
Medium
Data EngineerDebug a Hive Query for DAU
Data Manipulation (SQL/Python)
0
0
September 6, 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.