Bookings Vs Members - 3 times coupon Trail

Select P.*, Q.Active_date as MFT_date,Q.last_resev_date as last_resev_date, Q.daysdiff as active_period from
(select
distinct r.member_id as memberid,
m.display_name as name,
count(r.id) as reservations,
IFNULL(round(B.charges,2),0) as gross_rev,
round((IFNULL(B.charges,0) - IFNULL(A.coupon,0)),2) as net_rev,
round(IFNULL((IFNULL(A.coupon,0)/B.charges),0),2) as coupon_rate
from reservations r
join members m on m.id = r.member_id
left join
(select
p.member_id as mid, month(p.created_at + interval '8' hour) as month,Year(p.created_at + interval '8' hour) as year, IFNULL(p.amount,0) as coupon
from payments p
where p.state = 'normal' and p.paid_type = 'coupon'
group by p.member_id) A
on A.mid = r.member_id
left join
(select
c.member_id as mid, month(c.created_at + interval '8' hour) as month, Year(c.created_at + interval '8' hour) as year, sum(c.amount) as charges
from charges c
where c.state = 'normal' and c.kind IN ('rent' , 'oneway', 'd2d', 'mileage')
group by c.member_id) B
on B.mid = r.member_id
where m.imaginary in ('normal')
and r.member_id not in ('125', '127')
and r.state in ('completed','inUse')
group by memberid
order by gross_rev desc) P
join
(select
A.mid as mid, A.Mindate as Active_date, A.Maxdate as last_resev_date, DATEDIFF(A.Maxdate,A.Mindate) as daysdiff, A.resv as total_resv from
(select
distinct r.member_id as mid,
count(r.id) as resv,
Min(Date(r.start_at + interval '8' hour)) as Mindate,
Max(Date(r.start_at + interval '8' hour)) as Maxdate
from reservations r
join members m on m.id = r.member_id
where r.state in ('completed','inUse')
and m.imaginary in ('normal')
and r.member_id not in ('125', '127')
group by 1) A) Q
on Q.mid = P.memberid