Meta
Medium
Data ScientistCalculate Distinct High-View Posts and Spam View-Prevalence
Data Manipulation (SQL/Python)
0
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
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
Meta
Medium
Data ScientistCalculate Daily Harmful Content View Percentage
Data Manipulation (SQL/Python)
0
0
August 4, 2025
Meta
Medium
Data ScientistIdentify 3-Person Call Cycles in Video-Calling App
Data Manipulation (SQL/Python)
0
0
August 4, 2025
Meta
Easy
Data ScientistCompute reply-based user metrics in 7 days
Data Manipulation (SQL/Python)
0
0
December 18, 2025
Roblox
Easy
Data ScientistWrite SQL for influence score and follower growth
Data Manipulation (SQL/Python)
0
0
December 11, 2025
Uber
Easy
Data ScientistTransform DataFrame and compute diff-in-diff
Data Manipulation (SQL/Python)
0
0
December 11, 2025
Databricks
Easy
Data ScientistFind top-5 most similar rows across datasets
Data Manipulation (SQL/Python)
0
0
December 11, 2025
Meta
Easy
Data ScientistCompute percent of active users with 50+ calls
Data Manipulation (SQL/Python)
0
0
December 8, 2025
Meta
Easy
Data ScientistCompute active ad revenue by creation source
Data Manipulation (SQL/Python)
0
0
December 6, 2025
Pinterest
Easy
Data ScientistWrite SQL for top categories and highly active users
Data Manipulation (SQL/Python)
0
0
December 5, 2025
Databricks
Easy
Data ScientistCount weekly customers with ≥$1000 YTD spend
Data Manipulation (SQL/Python)
0
0
December 3, 2025
ByteDance
Easy
Data ScientistWrite monthly customer and sales SQL queries
Data Manipulation (SQL/Python)
0
0
November 27, 2025
Amazon
Easy
Data ScientistFind recommended friend pairs by shared listening
Data Manipulation (SQL/Python)
0
0
November 20, 2025
Glean
Easy
Data ScientistCompute DAU and rolling MAU with zero days
Data Manipulation (SQL/Python)
0
0
November 10, 2025
Intuit
Easy
Data ScientistCompute monthly signups, conversion, and YoY growth
Data Manipulation (SQL/Python)
0
0
November 8, 2025
ByteDance
Easy
Data ScientistFind top-paid employee per department
Data Manipulation (SQL/Python)
0
0
November 8, 2025
Intuit
Easy
Data ScientistPivot daily users and revenue by platform
Data Manipulation (SQL/Python)
0
0
November 8, 2025
Chime
Easy
Data ScientistCompute early signals for user retention
Data Manipulation (SQL/Python)
0
0
November 6, 2025
Cvs
Easy
Data ScientistCompute specialty spend share and top age band
Data Manipulation (SQL/Python)
0
0
October 17, 2025
Meta
Medium
Data ScientistWrite SQL to analyze shop visibility
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.