题解 | #获得积分最多的人(二)#

select user.id,user.name,g1.s_num from (select user_id,sum(grade_num) as s_num from grade_info group BY user_id ) g1 join user on g1.user_id = user.id

WHERE g1.s_num = ( select max(s_num) from (select user_id,sum(grade_num) as s_num from grade_info group BY user_id ) as g2

)

order by user.id