题解 | 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
②窗口函数直接计算平均值
查看3道真题和解析