RAYA Coupons D.O.D

select
Date((c.activated_at + interval '8' hour)) as date,
count(distinct case when c.comment = 'GRAB IFTAR' or c.comment = 'IFTAR TIME' or c.comment = 'GRABIFTAR5' then c.activated_at end) as grabiftar_activated,
count(distinct case when c.comment = 'GRAB IFTAR' or c.comment = 'IFTAR TIME' or c.comment = 'GRABIFTAR5' then c.used_at end) as grabiftar_used,
count(distinct case when c.comment = 'BREAK PASS' or c.comment = 'ONE RAMADHAN' then c.activated_at end) as Breakpass_activated,
count(distinct case when c.comment = 'BREAK PASS' or c.comment = 'ONE RAMADHAN' then c.used_at end) as Breakpass_used

from coupons c

where c.activated_at + interval '8' hour > '2019-05-01'

group by date