SQL — Having

Basic HAVING

SELECT department, COUNT(*) AS emp_count
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;

HAVING with aggregate

SELECT department, AVG(salary) AS avg_salary
FROM employees
GROUP BY department
HAVING AVG(salary) > 50000;

WHERE vs HAVING

-- WHERE filters before grouping
SELECT department, COUNT(*)
FROM employees
WHERE status = 'active'
GROUP BY department;

-- HAVING filters after grouping
SELECT department, COUNT(*)
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;

HAVING with multiple conditions

SELECT department, COUNT(*), AVG(salary)
FROM employees
GROUP BY department
HAVING COUNT(*) > 3 AND AVG(salary) > 40000;

Mini Practice

Write SQL code that:

1. Filters groups with HAVING
2. Uses aggregate functions in HAVING
3. Combines WHERE and HAVING
4. Uses multiple conditions in HAVING

Up Next

In the next lesson, you'll learn about Like — pattern matching.