题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
http://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
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
