题解 | #有取消订单记录的司机平均评分#
有取消订单记录的司机平均评分
https://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
select driver_id, round(avg(grade),1) avg_grade
from tb_get_car_order tgo
where driver_id in (
select distinct driver_id
from tb_get_car_order tgo
where start_time is null
and date_format(order_time, "%Y-%m") ='2021-10')
group by driver_id
union
select "总体" as driver_id, round(avg(grade),1) avg_grade
from tb_get_car_order tgo
where driver_id in (
select distinct driver_id
from tb_get_car_order tgo
where start_time is null
and date_format(order_time, "%Y-%m") ='2021-10')
