Type of SCDW by Date - Rahil

Select A.date as date,
sum(A.Basic_SCDW) as Basic_SCDW,
sum(A.Standard_SCDW) as Standard_SCDW,
sum(A.Premium_SCDW) as Premium_SCDW,
Round(sum(A.Basic_SCDW_amount),2) as Basic_SCDW_amount,
Round(sum(A.Standard_SCDW_amount),2) as Standard_SCDW_amount,
Round(sum(A.Premium_SCDW_amount),2) as Premium_SCDW_amount,
Round(sum(A.Basic_SCDW_amount)/sum(A.Basic_SCDW),2) as BASIC_SCDW_per_resv,
ROUND(sum(A.Standard_SCDW_amount)/sum(A.Standard_SCDW),2) as Standard_SCDW_per_resv,
ROUND(sum(A.Premium_SCDW_amount)/sum(A.Premium_SCDW),2) Premium_SCDW_per_resv

from
(select c.reservation_id as rid ,
Date(r.start_at + interval 8 hour) as date,
c.member_id as mid,
cm.meta as meta,
count(distinct case when cm.meta LIKE '%Basic SCDW%' then cm.charge_id end) as Basic_SCDW,
count(distinct case when cm.meta LIKE '%Standard SCDW%' then cm.charge_id end) as Standard_SCDW,
count(distinct case when cm.meta LIKE '%Premium SCDW%' then cm.charge_id end) as Premium_SCDW,
Sum(distinct case when cm.meta LIKE '%Basic SCDW%' then c.amount end) as Basic_SCDW_amount,
Sum(distinct case when cm.meta LIKE '%Standard SCDW%' then c.amount end) as Standard_SCDW_amount,
Sum(distinct case when cm.meta LIKE '%Premium SCDW%' then c.amount end) as Premium_SCDW_amount
from charges c
left join charge_meta  cm on cm.charge_id = c.id
left join reservations r on r.id = c.reservation_id
left join members m on m.id = c.member_id
where c.kind = 'insurance'
and m.imaginary in ('sofam', 'normal')
and r.member_id not in ('125', '127')
and r.state in ('completed','inUse')
and c.state = 'normal'
group by 1 ) A
Where A.date is not null
group by 1