Number of Cars and Car types by month - Sufian

select month(czl.log_date + interval 8 hour) as month,
Year(czl.log_date + interval 8 hour) as year,
cc.car_name as carname,
count(distinct czl.car_id) as ncars
from car_zone_logs czl left join cars c on czl.car_id = c.id
left join car_classes cc on c.car_class_id = cc.id
where year(czl.log_date + interval 8 hour) = '2019'
group by 1,2,3