MySQL — Having

Basic HAVING

SELECT category, COUNT(*) as count
FROM products
GROUP BY category
HAVING count > 10;

HAVING vs WHERE

-- WHERE filters before grouping
SELECT category, COUNT(*) as count
FROM products
WHERE price > 100
GROUP BY category;

-- HAVING filters after grouping
SELECT category, COUNT(*) as count
FROM products
GROUP BY category
HAVING count > 10;

HAVING Examples

-- Categories with average price > 500
SELECT category, AVG(price) as avg_price
FROM products
GROUP BY category
HAVING avg_price > 500;

-- Users with more than 5 orders
SELECT user_id, COUNT(*) as order_count
FROM orders
GROUP BY user_id
HAVING order_count > 5;

-- Departments with total salary > 100000
SELECT department, SUM(salary) as total_salary
FROM employees
GROUP BY department
HAVING total_salary > 100000;

-- Months with sales > 10000
SELECT
    MONTH(order_date) as month,
    SUM(total) as total_sales
FROM orders
GROUP BY MONTH(order_date)
HAVING total_sales > 10000;

Mini Practice

Write MySQL code that:

1. Uses HAVING with COUNT
2. Uses HAVING with AVG
3. Combines WHERE and HAVING
4. Filters grouped data

Up Next

Next: Learn about Distinct values.