TikTok
Medium
Data ScientistWrite SQL for last-7-day metrics without windows
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.
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
EY
Medium
Data ScientistArchitect cloud data ingestion patterns
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data EngineerAggregate Netflix metrics in SQL
Data Manipulation (SQL/Python)
1
1
August 4, 2025
DRW
Medium
Machine Learning EngineerImplement simulation-based portfolio optimizer in Python
Data Manipulation (SQL/Python)
0
0
July 31, 2025
Meta
Medium
Data EngineerWrite SQL and Python for data prep
Data Manipulation (SQL/Python)
1
1
July 15, 2025
Meta
Medium
Data ScientistAnalyze spend and creation-source shifts
Data Manipulation (SQL/Python)
0
0
March 1, 2026
Meta
Medium
Product AnalystWrite Call Analytics SQL Queries
Data Manipulation (SQL/Python)
0
0
January 28, 2026
Other
Medium
Data ScientistDesign MapReduce and Spark jobs
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
Character
Medium
Data ScientistWrite SQL for character safety and engagement metrics
Data Manipulation (SQL/Python)
0
0
September 13, 2025
Meta
Medium
Data EngineerOptimize SQL to minimize scans
Data Manipulation (SQL/Python)
2
0
September 6, 2025
Marshall Wace
Medium
Software EngineerFind users with multi-country successful logins
Data Manipulation (SQL/Python)
0
0
August 13, 2025
Apple
Medium
Data ScientistCompute and Rank Store Revenue by Region Using Pandas
Data Manipulation (SQL/Python)
0
0
August 4, 2025
Meta
Medium
Data ScientistIdentify Duplicate Posts by User and Date
Data Manipulation (SQL/Python)
1
0
August 4, 2025
Meta
Medium
Data ScientistCalculate Distinct High-View Posts and Spam View-Prevalence
Data Manipulation (SQL/Python)
0
1
August 4, 2025
Meta
Medium
Data ScientistCalculate Daily Harmful Content View Percentage
Data Manipulation (SQL/Python)
0
1
August 4, 2025
Instacart
Medium
Software EngineerPivot data without date libraries
Data Manipulation (SQL/Python)
0
0
July 31, 2025
Citi
Medium
Data ScientistCompute 30-day power users and 7-day retention
Data Manipulation (SQL/Python)
0
0
March 25, 2025
Wayfair
Easy
Data ScientistFind top buyer in earliest 10-year window
Data Manipulation (SQL/Python)
0
0
February 18, 2026
Meta
Medium
Data ScientistWrite SQL for seller and category metrics
Data Manipulation (SQL/Python)
0
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.