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.