题解 | #获得积分最多的人(三)#
获得积分最多的人(三)
https://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
with t1 as(
select id,name,sum(case when type = "add" then grade_num else -grade_num end) grade_num
from
user join grade_info on user.id = grade_info.user_id
group by id,name
order by id
)
select id,name,grade_num
from t1
where grade_num = (
select max(grade_num) from t1
)
