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

注意点：找到21年10月有过取消订单记录的司机，只要在该时间段有取消记录则都计入

with rollup： 写在分组函数之后，会对分组后的数据进行汇总。用的比较少，这里记录一下

select ifnull(co.driver_id, '总体') as driver_id,
    round(avg(co.grade), 1) as avg_grade
from tb_get_car_order co
where co.driver_id in (
    select co.driver_id
    from tb_get_car_order co
    where co.fare is null
        and co.finish_time between '2021-10-01' and '2021-11-01'
)
group by co.driver_id 
with rollup