题解 | #有取消订单记录的司机平均评分#
有取消订单记录的司机平均评分
https://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
# tb1：找到有取消过订单的司机id列表 select ifnull(driver_id,'总体') as driver_id,round(avg(grade),1) as avg_grade from tb_get_car_order where driver_id in (select distinct driver_id from tb_get_car_order where start_time is null AND year(order_time) = 2021 AND month(order_time) = 10) #有取消记录的司机 AND grade is not null group by driver_id with rollup
