先写一个子函数,把每个用户的累计积分算出来,然后再筛选最大的积分用户
select a.name, max(a.s) from (select name, sum(grade_num) s from grade_info left join user on grade_info.user_id=user.id group by name)a;