题解 | #有取消订单记录的司机平均评分#
有取消订单记录的司机平均评分
https://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
认为是最容易理解的思路~ select driver_id, round(sum(grade)/count(grade),1) from tb_get_car_order where driver_id in (select driver_id from tb_get_car_order where grade is null and date_format(order_time,'%Y-%m')='2021-10') group by driver_id union select '总体' as driver_id, round(sum(grade)/count(grade),1) from tb_get_car_order where driver_id in (select driver_id from tb_get_car_order where grade is null and date_format(order_time,'%Y-%m')='2021-10')
查看10道真题和解析
