题目
解答
select b.user_id as id,c.name,b.cnt
from ( select a.user_id,a.cnt,rank() over (order by a.cnt desc) as ranking
from ( select user_id,sum(grade_num) as cnt
from grade_info
where type = "add"
group by user_id ) a ) b
left join user as c
on b.user_id = c.id
where b.ranking = 1
order by b.user_id;