题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
with t1 as( select user_id,sum(grade_num) grade_num from grade_info group by user_id ) select id,name,grade_num from t1 join user on t1.user_id = user.id where grade_num = ( select max(grade_num) from t1 )