Weekday Vs Weekend - One Way - Becca and Rahil

select * from

(select
r.id,
Date(r.return_at + interval '8' hour) as date,
if(weekday(r.return_at + interval '8' hour) = '6' or weekday(r.return_at + interval '8' hour) = '0' ,'Weekend' , 'weekday') as weekday_Weekend,
r.start_zone_id as zoneid
from reservations r
join members m
on r.member_id = m.id
where r.return_at + interval '8' hour >= curdate() - interval 180 day
and r.state = 'completed'
and r.way = 'oneway'
and r.end_zone_id in ('244','245')
and m.state = 'normal'
and m.imaginary = 'normal'
group by r.id) A