WITH t AS ( SELECT city,driver_id,ROUND(AVG(grade),1) avg_grade, ROUND(COUNT(*)/COUNT(DISTINCT DATE(order_time)),1) avg_order_num, ROUND(SUM(mileage)/COUNT(DISTINCT DATE(order_time)),3) acg_mileage, DENSE_RANK()OVER(partition by city order by AVG(grade) DESC) dr FROM tb_get_car_record r JOIN tb_get_...