Multiple conditions

Use AND and OR inside HAVING.

Multiple conditions

You can combine multiple conditions in HAVING with AND and OR.

SELECT category, COUNT(*), SUM(price)
FROM products
GROUP BY category
HAVING COUNT(*) > 3 AND SUM(price) > 200;

This query returns categories with many products and high totals.

category, COUNT(*), SUM(price) is selected from products. Rows are grouped by category; aggregate functions are computed per group. HAVING COUNT(*) > 3 AND SUM(price) > 200 runs after grouping and drops groups that fail the condition.

Multiple conditions — details

AND requires both conditions, OR at least one. Parentheses set precedence.

For example, HAVING COUNT(*) > 3 AND SUM(price) > 200 keeps categories that are both large and high in total value.

Exercise Multiple conditions

Combine COUNT(*) > 3 AND SUM(price) > 200 in HAVING.

Show example solution

SELECT category, COUNT(*), SUM(price)
FROM products
GROUP BY category
HAVING COUNT(*) > 3 AND SUM(price) > 200;

Test yourself

Add AND

HAVING COUNT(*) > 3 ____ SUM(price) > 200;

Show answer

HAVING COUNT(*) > 3 AND SUM(price) > 200;

What does AND require?
- Only one of them
- None
- Some of them
- Both conditions
Show answer

Both conditions — AND requires both conditions to be true.
Multiple conditions: match the terms

AND

both
OR

at least one
NOT

not
HAVING

group filter

Next lesson: HAVING with aliases

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies