Number and Type of cars per each Zone - For Utilization Rate

select

c.id as carid,
cc.id as carclassid,
z.region as Region,
date(cz.created_at + interval '8' hour) as day,
cc.car_name as carname

from cars as c

join car_classes as cc
on c.car_class_id = cc.id

join zones as z
on z.id = c.zone_id

join car_zone_logs as cz
on c.id = cz.car_id

where cz.car_state = 'Normal'
and z.state = 'normal'

group by c.id