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

with
tb1 as(
    select id, name, case when type = 'reduce' then -1 * grade_num else grade_num end as grade_num1
    from grade_info
    left join user on grade_info.user_id = user.id
),
tb2 as(
    select id, name, sum(grade_num1) as grade_num from tb1
    group by id, name
)
select id, name, grade_num from tb2
where grade_num = (
    select max(grade_num) from tb2
)
order by id