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

(
select o.driver_id, round(avg(o.grade),1) avg_grade
from tb_get_car_order o
where o.driver_id in (select o.driver_id from tb_get_car_order o where o.start_time is null and o.order_time like '2021-10%')
group by o.driver_id
order by o.driver_id
)
Union ALL
(
select '总体' as driver_id,round(avg(o.grade),1) as avg_grade
from tb_get_car_order o
where driver_id in (select driver_id from tb_get_car_order o
                    where o.start_time is null and o.order_time like '2021-10%')
)