coupon vs non coupon users- Rahil

set @startdate1 = '2019-11-01';
set @startdate2 = '2020-12-01';
use socar_malaysia;
select month(A.return_date) as return_date,
count(distinct case when A.coupon is null then A.rid end) as non_Coupon_Users,
count(distinct case when A.coupon is not null then A.rid end) as coupon_users,
count(distinct case when A.coupon is null then A.rid end)/count(A.rid) as non_Coupon_Users_PCT,
count(distinct case when A.coupon is not null then A.rid end)/count(A.rid) as coupon_users_PCT
from
(select
distinct r.id as rid, r.member_id as mid,co.comment as coupon,
Date(r.return_at + interval '8' hour) as return_Date
from reservations r left join members m on r.member_id = m.id
left join coupons co on co.reservation_id = r.id
where r.state in ('completed')
and r.return_at + interval 8 hour >= @startdate1
and r.return_at + interval 8 hour <= @startdate2
and m.imaginary in ('sofam', 'normal')
and r.member_id not in ('125', '127')
group by rid) A
group by 1