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

with t1 as(
    select user_id,name,sum(if(type='add',grade_num,-grade_num)) grade
    from grade_info
    left join user
    on user.id=grade_info.user_id
    group by user_id,name  
)
select t1.*
from t1
where grade = (select max(grade) max_grade from t1)