Initializing...

Chapter 4: Aggregation

4-3

Your Progress

Progress

0/22 lessons

Completed

lessons done

Chapters

completed

Streak

days

HAVING Clause

The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.

Use HAVING to filter groups after the aggregation.

SELECT category, COUNT(*) 
FROM products 
GROUP BY category
HAVING COUNT(*) > 5;

Task: Find which status has more than 1 order.

Run a query to see results