题解 | #获得积分最多的人(三)#
获得积分最多的人(三)
https://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
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
),
t2 as(
select max(grade) max_grade
from t1
)
select t1.*
from t1
where grade = (select max(grade) max_grade from t1)
百度一面671人在聊
投递大疆等公司7个岗位