13.2 How to Keep Groups with HAVING SUM(amount) Above a Target

Example 1 · dataset: northstar_bank

SELECT branch_id,
       strftime('%Y-%m', posted_at) AS month,
       SUM(amount)                  AS total_inr
FROM transactions
WHERE branch_id IN (3, 4)
GROUP BY branch_id, month
HAVING SUM(amount) > 100000
ORDER BY branch_id, month;

Output

Meaning. Only the branch months above 1,00,000 rupees remain. Pune in August and October stay out, because their totals are below that target.

Example 2 · dataset: northstar_bank

SELECT strftime('%Y-%m', posted_at) AS month,
       SUM(amount)                  AS total_gbp
FROM transactions
WHERE branch_id = 1
GROUP BY month
HAVING SUM(amount) > 5000
ORDER BY month;

Output

Meaning. For London, August and September stay below 5,000 pounds. Only October crosses the target, with 7,950 pounds.