Hoon Type of Cohort

select
A.memberid as memberid,
B.rid as rid,
B.reservationdate as res_date,
Date(A.MFTDate) as MFTdate,
date(A.lastactivedate) as lastactivedate

from
(select
m.id as memberid,
r.id as rid,
Date(r.start_at + interval '8' hour) as reservationdate
from  members m
left outer join reservations r on m.id = r.member_id
Where r.start_at != 0
and m.imaginary = 'normal'
and r.state = 'completed'
group by m.id,r.id) B

left join

(select
m.id as memberid,
TIMESTAMPDIFF(YEAR, str_to_date(m.birthday, '%Y%m%d'), Now()) AS age,
min(r.start_at) as MFTdate,
Max(r.start_at) as lastactivedate
from  members m
left outer join reservations r on m.id = r.member_id
join charges c on m.id = c.member_id
Where r.start_at != 0
and m.imaginary = 'normal'
and c.kind = 'subscriptionFee'
and r.state = 'completed'
group by m.id) A

on B.memberid = A.memberid