题解 | #各个视频的平均完播率#
有取消订单记录的司机平均评分
http://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
这个题目的难度完全不在于编写代码，而是读这个超长的题，头真大，说的太啰嗦了。 select coalesce(driver_id,'总体'),round(avg(grade),1) from tb_get_car_order where start_time is not null and driver_id in (select driver_id from tb_get_car_order where DATE_FORMAT(order_time,'%Y-%m')='2021-10' and start_time is null ) group by driver_id with rollup
