题解 | 获得积分最多的人(三)
获得积分最多的人(三)
https://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
with t as (
select user_id, sum(grade) as grade
from (
select user_id,
case when type='add' then grade_num else -grade_num end as grade
from grade_info
) temp
group by user_id
)
select id, name, grade as grade_num
from (
select user_id, grade, dense_rank() over (order by grade desc) as dr
from t
) temp join user on temp.user_id=user.id
where dr=1
order by id
OPPO公司福利 1077人发布
，实习薪资开高一点也行吧
