Meta
Medium
Data ScientistWrite dating profile report with final reviews
Data Manipulation (SQL/Python)
3
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.
635Questions
102Companies
Easy 52 • Medium 539 • Hard 7Difficulty 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 ScientistCompute view prevalence from views and labels
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Meta
Medium
Data EngineerRecommend two-hop follows in Python
Data Manipulation (SQL/Python)
0
0
August 1, 2025
Meta
Easy
Data ScientistCompute active ad revenue by creation source
Data Manipulation (SQL/Python)
0
0
December 6, 2025
Chime
Easy
Data ScientistCompute early signals for user retention
Data Manipulation (SQL/Python)
3
0
November 6, 2025
Shopify
Medium
Data ScientistJustify and harden your analytics and BI stack
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Upstart
Medium
Data ScientistWrite monthly touches and last-touch SQL
Data Manipulation (SQL/Python)
3
0
October 13, 2025
EY
Medium
Data ScientistDesign a data platform enablement
Data Manipulation (SQL/Python)
3
0
October 13, 2025
NVIDIA
Medium
Software EngineerAnalyze and debug Python utilities
Data Manipulation (SQL/Python)
3
0
August 7, 2025
Newyorktimes
Medium
Data AnalystWrite SQL for content view metrics by device
Data Manipulation (SQL/Python)
3
0
March 1, 2022
Meta
Medium
Data ScientistAnalyze spend cohort and source shifts
Data Manipulation (SQL/Python)
3
0
February 23, 2026
TikTok
Easy
Data ScientistFind top-paid employee per department
Data Manipulation (SQL/Python)
3
0
November 8, 2025
Pinterest
Medium
Data ScientistFind top category by video time spent
Data Manipulation (SQL/Python)
2
0
October 13, 2025
Pinterest
Medium
Data ScientistCompute CTR by pin_format and date
Data Manipulation (SQL/Python)
2
0
October 13, 2025
Capital One
Medium
Data ScientistMerge CSVs and build revenue pivot with pandas
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Apple
Medium
Data ScientistDetect sessions and gaps using SQL LEAD
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Coinbase
Medium
Data ScientistWrite SQL: sum values ≤ each row’s value
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Amazon
Medium
Data ScientistVerify subscriptions and analyze orders with SQL/Python
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Meta
Medium
Data ScientistCompute feed ad frequency and retention in SQL
Data Manipulation (SQL/Python)
3
0
October 13, 2025
Meta
Easy
Analytics EngineerCompute daily active ads
Data Manipulation (SQL/Python)
3
0
February 15, 2026
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.