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