Queries for < 23 Years old project

set @startDate = "2017-01-01 00:00:00";

select distinct A.mid, A.age, A.car_name, count(A.rid) as resv from
(select
distinct c.reservation_id as rid,cc.car_name as car_name,
r.car_id as cid,
m.id as mid,
YEAR(r.start_at) - YEAR(m.birthday) as age
from charges c
left join members m on m.id = c.member_id
left join reservations r on r.id = c.reservation_id
left join cars cr on cr.id = r.car_id
left join car_classes cc on cc.id = cr.car_class_id
where c.kind = 'accident'
and date(c.created_at + interval '8' hour) >= @startdate
group by 1) A
where A.age < 100
group by 1;

set @startDate = "2017-01-01 00:00:00";

select distinct A.mid, A.age, A.resv from
(select
distinct r.member_id as mid,
Count(r.id) as resv,
YEAR(r.start_at) - YEAR(m.birthday) as age
from reservations r
left join members m on m.id = r.member_id
where date(r.start_at + interval '8' hour) >= @startdate
and m.imaginary in ('sofam', 'normal')
and r.state = 'completed'
group by 1) A
where A.age < 100
group by 1;