Jevin Query - For Cars vs Region vs Specific Time

select
distinct m.id,
r.id as rid,
c.id as carid,
cc.id as carclassid,
z.name as zonename,
date(r.occupy_start_at + interval '8' hour) as day,
timestampdiff(minute,r.start_at, r.end_at)/60 as ridelength,
#TIMESTAMPDIFF(hour,CONVERT_TZ(r.occupy_start_at, '+00:00', '+8:00'),CONVERT_TZ(r.occupy_end_at, '+00:00', '+8:00')) as ridelength,
hour(r.occupy_start_at + interval '8' hour) as startingtime,
TIMESTAMPDIFF(minute,r.occupy_start_at + interval '8' hour,r.occupy_end_at + interval '8' hour) as ridelengthinminutes,
TIMESTAMPDIFF(day,c.created_at + interval '8' hour,'2019-1-1 00:00') as activedays,
weekday(r.occupy_start_at + interval '8' hour) as startingday,
cc.car_name as carname,
sum(p.amount) as amount


from reservations r

join zones z
on z.id = r.end_zone_id

join cars c on c.zone_id = z.id

join car_classes cc on cc.id = c.car_class_id

left outer join members m on m.id = r.member_id

left outer join payments p on p.reservation_id = r.id


where CONVERT_TZ(r.start_at, '+00:00', '+8:00') >= '2019-1-1 00:00'
and CONVERT_TZ(r.start_at, '+00:00', '+8:00') < '2019-2-1'
and m.imaginary = 'normal'
and m.state = 'normal'
and r.state IN ('completed')
and p.state = 'normal'

group by 1,2

order by 13 desc