题解 | #获得积分最多的人(一)#
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
SELECT user.name, SUM(grade_num) OVER( PARTITION BY user_id ) AS total_num FROM grade_info JOIN user ON grade_info.user_id = user.id WHERE type = 'add' ORDER BY total_num DESC LIMIT 1