SQL HAVING Clause - Filtering Grouped Data

Filter Employees by Department Count

Write a SQL query to find departments with more than 10 employees using HAVING.

Expected output: List of department IDs with employee counts greater than 10.

Hint: Use GROUP BY department_id and COUNT(employee_id) in HAVING.

Find Products with High Average Price

Create a query to list products whose average price is above 50 using HAVING.

Expected output: Product IDs with average price greater than 50.

Hint: Use AVG(price) in HAVING clause.

WHERE filters rows before aggregation and cannot use aggregate functions, while HAVING filters groups after aggregation and can use aggregate functions.

Yes, but it is uncommon. HAVING without GROUP BY filters the entire result set as a single group, typically used with aggregate functions.

You use HAVING to filter results based on aggregate values after grouping, which WHERE cannot do because it filters individual rows before aggregation.