题解 | #2021年国庆在北京接单3次及以上的司机统计信息#

1.t1表 2021年国庆7天在北京接单3次及以上的司机的接单数目和收入数目

注意司机接单但被用户取消的订单也算在接单数内

2.计算平均接单数和平均兼职收入

select '北京' as city,
round(avg(cnt),3) avg_order_num,
round(avg(income),3) avg_income
from 
(select 
driver_id, count(t2.order_id) cnt,
sum(fare) income
from 
tb_get_car_order t1 
join 
tb_get_car_record t2
using(order_id)
where date(order_time) between '2021-10-01' and '2021-10-07'
and city='北京'
group by driver_id
having cnt>=3)t1