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

京公网安备 11010502036488号