题解 | #2021年国庆在北京接单3次及以上的司机#
2021年国庆在北京接单3次及以上的司机统计信息
https://www.nowcoder.com/practice/992783fd80f746d49e790d33ee537c19
select
"北京" city,
round(AVG(driver_order),3) avg_order_num,
round(AVG(money),3) avg_income
from(
select city,count(order_id) driver_order,sum(fare) money
from
tb_get_car_record join tb_get_car_order
using(order_id )
where
city = "北京" and DATE_FORMAT(order_time,"%Y%m%d") BETWEEN '20211001' AND '20211007'
group by driver_id
having driver_order > 2
)t
投递快手等公司10个岗位