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

select distinct r.city, round(avg(count(order_time)) over(),3) avg_order_num, round(avg(sum(fare)) over(),3) avg_income
from tb_get_car_order o
join tb_get_car_record r
on o.order_id = r.order_id
where r.city='北京' 
and  o.order_time between '2021-10-01' and '2021-10-07'
group by r.city, o.driver_id
having count(o.order_time)>=3

注意：

①distinct city

②窗口函数直接计算平均值