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

SELECT
    COALESCE(driver_id,'总体') ,
    round(sum(grade) / count(grade),1)
from
    tb_get_car_order
where
     driver_id in(select driver_id from tb_get_car_order where start_time is null and DATE_FORMAT(finish_time,'%Y-%m') = '2021-10')
group by
    driver_id WITH ROLLUP