Aggregated groups filter করে।

Example:

যেসব customer-এর 10 বা তার বেশি orders আছে।

SELECT
    user_id,
    COUNT(*) AS order_count
FROM orders
GROUP BY user_id
HAVING COUNT(*) >= 10;

WHERE vs HAVING Example

SELECT
    user_id,
    SUM(amount) AS revenue
FROM orders
WHERE status = 'completed'
GROUP BY user_id
HAVING SUM(amount) > 10000;

Flow:

First:
Only completed orders

Then:
Group by user

Then:
Keep users with revenue > 10k