HAVING with aggregates

Filter groups by COUNT or SUM.

HAVING with aggregates

With HAVING you test aggregates like SUM, AVG, MIN, MAX. It sets a condition per group.

SELECT customer_id, SUM(amount) AS total
FROM orders
GROUP BY customer_id
HAVING SUM(amount) > 500;

This query returns customers who spent over 500.

customer_id, SUM(amount) AS total is selected from orders. Rows are grouped by customer_id; aggregate functions are computed per group. HAVING SUM(amount) > 500 runs after grouping and drops groups that fail the condition.

HAVING with aggregates — details

Using an aggregate function in HAVING is essential. Otherwise WHERE would suffice.

A condition on the group column (e.g. category = 'Kitap') is more efficient in WHERE; save HAVING for aggregates such as COUNT and SUM.

Exercise HAVING with aggregates

Compute per-customer totals with SUM(amount) and keep those over 500 with HAVING.

Show example solution

SELECT customer_id, SUM(amount) AS total
FROM orders
GROUP BY customer_id
HAVING SUM(amount) > 500;

Test yourself

HAVING with aggregates: match the terms

SUM

sum
AVG

average
MIN

minimum
MAX

maximum

Add SUM

SELECT customer_id, ____(amount) AS total
FROM orders
GROUP BY customer_id
HAVING SUM(amount) > 500;

Show answer

SELECT customer_id, SUM(amount) AS total
FROM orders
GROUP BY customer_id
HAVING SUM(amount) > 500;

What is used in HAVING?
- The column name
- JOIN
- An aggregate function
- LIMIT
Show answer

An aggregate function — An aggregate function is used in HAVING.

Next lesson: Multiple conditions

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies