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

with t1 as(
    
    select max(grade) max_grade_num
    from 
    (select user_id,sum(grade_num) grade
    from grade_info
    group by user_id) t

),
t2 as(
    select user_id,name,sum(grade_num) grade
    from grade_info
    left join user
    on user.id=grade_info.user_id
    group by user_id,name  
)

select t2.*
from t2
left join t1
on t1.max_grade_num=t2.grade
where max_grade_num is not null