WITH t1 AS(SELECT user_id, SUM(grade_num) AS grade_sum, RANK() OVER(ORDER BY SUM(grade_num) DESC) AS r_numberFROM grade_infoGROUP BY user_id)SELECT t1.user_id, user.name, t1.grade_sumFROM t1INNER JOIN userON t1.user_id = user.idWHERE ...