WITH t1 AS ( SELECT a.uid, driver_id, date( order_time ) AS order_time, mileage, grade, city FROM tb_get_car_order a LEFT JOIN tb_get_car_record b USING ( order_id ) ), t2 AS ( SELECT RANK() over ( PARTITION BY city ORDER BY round( sum( grade )/ count( grade ), 1 ) DESC ) AS rank_num, city, driver_i...