select city,driver_id,avg_grade,avg_order_num,avg_mileage from (select *,max(avg_grade) over (partition by city) max_grade from (select city,driver_id,round(avg(grade),1) avg_grade, round(count(1)/count(distinct date(order_time)),1) avg_order_num, round(sum(mileage)/count(distinct date(order_time)),...