select ifnull(driver_id,'总体') as driver_id,round(avg(grade),1) as avg_grade
from tb_get_car_record join tb_get_car_order using(order_id)
where
driver_id in (select driver_id from tb_get_car_order
where start_time is null and date(order_time) between '2021-10-1'and '2021-10-31')
group by driver_id
with rollup
时间是对取消订单来说的

京公网安备 11010502036488号