题解 | #2021年国庆在北京接单3次及以上的司机统计信息#
2021年国庆在北京接单3次及以上的司机统计信息
http://www.nowcoder.com/practice/992783fd80f746d49e790d33ee537c19
with a as ( select driver_id, city, count(x.order_id) as cc, sum(fare) as ss from tb_get_car_order x join tb_get_car_record y using(order_id) where city = '北京' and date(finish_time) between '2021-10-01' and '2021-10-07' group by 1, 2 having count(order_id) >= 3 ) select '北京', round(avg(a.cc), 3), round(avg(a.ss), 3) from a
投递卓越教育等公司9个岗位 >