题解 | #获得积分最多的人(一)#

select distinct name,sum(grade_num) over (partition by name) as grade_num
from (select a.user_id,a.grade_num,b.name
from grade_info as a 
inner join user as b 
on a.user_id=b.id) as c
order by grade_num DESC
limit 1