05 Empty

-- 05_empty: Distinguish an empty aggregate from zero
-- Read-only reference query. Setup must be loaded first.
SELECT COUNT(*) AS row_count, SUM(amount) AS raw_sum,
 COALESCE(SUM(amount),0) AS display_sum
FROM aabha_sql.refunds WHERE refund_date >= DATE '2026-01-01';