SELECT name ,t FROM user u RIGHT JOIN (SELECT user_id,SUM(grade_num) OVER (PARTITION BY user_id) t FROM grade_info ORDER BY t DESC LIMIT 1) a ON u.id = a.user_id ORDER BY t DESC