Shiva - Time Taken - Signup to MFT

select
    min(r.id) as rid,
    m.id as mid,
    date(m.created_at + interval 8 hour) as member_Created,
    date(min(r.return_at + interval 8 hour)) as start_date,
    timestampdiff(day, m.created_at, min(r.start_at)) as idle_time,
    round(timestampdiff(minute, min(r.start_at), min(r.end_at))/60,2) as dur,
    ifnull(c.comment, 'None') as promo,
    round(ifnull(c.rev,0),2) as rev,
    round((ifnull(c.rev,0) - IFNULL(p.coupon,0)),2) as net_rev,
    round(ifnull((ifnull(p.coupon,0)/c.rev),0),2) as coupon_rate,
    ct.cname as model
from reservations r
left join members m on r.member_id = m.id
left join coupons c on c.reservation_id = r.id
left join zones z on r.start_zone_id = z.id
left join (select ifnull(payments.amount,0) as coupon, payments.reservation_id as rid from payments where payments.state = 'normal' and payments.paid_type = 'coupon') as p on p.rid = r.id
left join (select sum(charges.amount) as rev, charges.reservation_id as rid from charges where charges.state = 'normal' and charges.kind IN ('rent' , 'oneway', 'd2d', 'mileage') group by charges.reservation_id) as c on r.id = c.rid
left join (select cars.id as cid, car_classes.car_name as cname from cars left join  car_classes on cars.car_class_id = car_classes.id) as ct on r.car_id = ct.cid
where r.state in ('completed') and m.imaginary in ('normal', 'sofam')
group by mid