SELECT now() AT TIME ZONE 'Asia/Kolkata' AS run_at_ist, current_user; run_at_ist | current_user ----------------------------+-------------- 2026-10-29 15:09:14.602514 | nl2sql_full (1 row) SELECT COUNT(*) AS delivered_90d_to_sep2 FROM orders WHERE status = 'delivered' AND placed_at >= TIMESTAMPTZ '2026-06-05 00:00+00' AND placed_at < TIMESTAMPTZ '2026-09-03 00:00+00'; delivered_90d_to_sep2 ----------------------- 42 (1 row) SELECT COUNT(*) AS delivered_placed_90d_to_today FROM orders WHERE status = 'delivered' AND placed_at >= date_trunc('day', now()) - INTERVAL '90 days' AND placed_at < date_trunc('day', now()); delivered_placed_90d_to_today ------------------------------- 95 (1 row) SELECT COUNT(*) AS delivered_at_90d_to_today FROM orders WHERE status = 'delivered' AND delivered_at >= date_trunc('day', now()) - INTERVAL '90 days' AND delivered_at < date_trunc('day', now()); delivered_at_90d_to_today --------------------------- 97 (1 row)