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

select
name
,cnt
from
(
    select
    name
    ,sum(grade_num) cnt
    ,row_number()over(order by sum(grade_num) desc) rank1
    from grade_info t1 join user t2
    on t1.user_id = t2.id
    group by 1
)table1
where rank1 = 1