-- 普普通通没啥新意但是正确的解法 select u.name,sum(grade_num) grade_sum from grade_info g left join user u on g.user_id=u.id group by user_id order by grade_sum desc limit 1;