QUERY PLAN
Aggregate (cost=5.32..5.33 rows=1 width=8)
-> Seq Scan on promotion_ongoing (cost=0.00..5.32 rows=1 width=0)
Filter: (((join_date)::text >= '2025-04-15 00:00:00'::text) AND ((join_date)::text <= '2025-04-22 23:59:59'::text))