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

(select
driver_id,
round(avg(grade),1) as avg_grade
from tb_get_car_order
# where date_format(order_time,'%Y-%m')='2021-10'
where grade is not null
and driver_id in(
    select driver_id
    from tb_get_car_order
    where start_time is null
    and date_format(order_time,'%Y-%m')='2021-10'
)
group by driver_id
order by driver_id)
union all
(select
'总体' as driver_id2,
round(avg(grade),1) as avg_grade2
from tb_get_car_order
# where date_format(order_time,'%Y-%m')='2021-10'
where grade is not null
and driver_id in(
    select driver_id
    from tb_get_car_order
    where start_time is null
    and date_format(order_time,'%Y-%m')='2021-10'
))