QUERY PLAN
Aggregate (cost=5.37..5.38 rows=1 width=8)
-> Seq Scan on promotion_ongoing (cost=0.00..5.37 rows=1 width=0)
Filter: (((join_date)::text >= '2025-06-18 00:00:00'::text) AND ((join_date)::text <= '2025-06-25 23:59:59'::text) AND ((member_id)::text = '1ef1c781-e6fe-611a-a45f-5e1409fc0711'::text))