题解 | #有取消订单记录的司机平均评分#

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 

时间是对取消订单来说的