题解 | 有取消订单记录的司机平均评分
有取消订单记录的司机平均评分
https://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
select ifnull(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 grade is null) group by driver_id with rollup
二刷
