Shiva query for total members and total cars

set @startDate = "2019-03-01 00:00:00";
set @monthInterval = 1;

SELECT
    DATE(CONVERT_TZ(reservations.start_at, '+00:00', '+8:00')) as start_date,
    COUNT(DISTINCT reservations.car_id) as total_cars
FROM
    reservations
LEFT JOIN members on members.id = reservations.member_id
WHERE
    reservations.state = 'completed'
		AND members.imaginary in ('sofam', 'normal')
        AND DATE(CONVERT_TZ(reservations.start_at, '+00:00', '+8:00')) >= @startDate
GROUP BY start_date
;

select log_date, count(car_zone_logs.car_id) as total_cars from car_zone_logs
where car_state = 'normal' and zone_state = 'normal' AND CONVERT_TZ(log_date, '+00:00', '+8:00') >= @startDate AND CONVERT_TZ(log_date, '+00:00', '+8:00') < DATE_ADD(@startDate, INTERVAL @monthInterval MONTH)
group by log_date