题解 | #有取消订单记录的司机平均评分#
有取消订单记录的司机平均评分
https://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
我的笨办法：用union all 实现
select driver_id,round(avg(grade),1)as avg_grade
from tb_get_car_order
where driver_id in
(select driver_id
from tb_get_car_order
where month (order_time)=10
and start_time is null)
and grade is not null
group by 1
union all
select "总体" as driver_id,round(avg(grade),1)as avg_grade
from tb_get_car_order
where driver_id in
(select driver_id
from tb_get_car_order
where month (order_time)=10
and start_time is null)
and grade is not null;
你cet6就cet6，cet4就cet4，你写个cet证书等是什么意思。专业技能快赶上项目行数，你做的这2个项目哪里能提现你有这么多技能呢