题解 | #获得积分最多的人(三)#
获得积分最多的人(三)
http://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
with t as (select ,sum((grade_num)(if(type='add',1,-1))) as grade_sum from grade_info
group by user_id)
select id,name,grade_sum
from t,user
where id=user_id
and grade_sum=(select max(grade_sum)from t)
order by id;