Spot the bug SQL
1
-- July revenue by region, paid orders only.
2
SELECT region,
3
ROUND(SUM(amount), 2) AS revenue
4
FROM orders
5
WHERE placed_at BETWEEN '2026-07-01' AND '2026-07-31'
6
AND status = 'paid'
7
GROUP BY region
8
ORDER BY revenue DESC;