题解 | #有取消订单记录的司机平均评分#
有取消订单记录的司机平均评分
http://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
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 start_time is null ) group by driver_id
union
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 start_time is null )
order by driver_id ASC
投递深圳同为数码等公司10个岗位
拼多多集团-PDD公司氛围 517人发布