One way Push Notifications - Rahil for Becca

select
D.mid,
D.name,
D.email,
D.age
from reservations r
left outer join (select
c.reservation_id as rid,
c.member_id as mid,
m.display_name as name,
m.email as email,
YEAR(r.start_at) - YEAR(m.birthday) as age,
c.kind as kind
from charges c
join members m on c.member_id =m.id
left join reservations r on r.member_id = c.member_id
where c.created_at + interval '8' hour >= '2019-1-1'
and c.kind = 'subscriptionFee'
) D on D.mid = r.member_id
where r.created_at + interval '8' hour >= '2019-1-1'
and D.mid is not null
and r.way = 'oneway'
group by 1;

select
D.mid,
D.name,
D.email,
D.age
from reservations r
left outer join (select
c.reservation_id as rid,
c.member_id as mid,
m.display_name as name,
m.email as email,
YEAR(r.start_at) - YEAR(m.birthday) as age,
c.kind as kind
from charges c
join members m on c.member_id =m.id
left join reservations r on r.member_id = c.member_id
where c.created_at + interval '8' hour >= '2019-1-1'
and c.kind = 'subscriptionFee'
) D on D.mid = r.member_id
where r.created_at + interval '8' hour >= '2019-1-1'
and D.mid is not null
and r.way = 'onewayReturn'
group by 1;