Reservation Split by month, year and Gender- Rahil for Sufia

select
year(r.return_at + interval '8' hour) as year,
month(r.return_at + interval '8' hour) as month,
ifnull(dl.gender,"") as gender,
count(r.id) as resv
from reservations r
left join members m on m.id = r.member_id
left join driver_licenses dl on dl.member_id = m.id
where m.imaginary in ('sofam', 'normal')
    and r.member_id not in ('125', '127')
    and r.start_zone_id not in (2, 3, 101)
    and r.state in ('completed')
    and year(r.return_at + interval '8' hour) is not null
    and dl.gender not in ('unknown')
group by 1,2,3
order by 1 desc