题解 | 获得积分最多的人(一)
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
SELECT
u.name,
SUM(g.grade_num) as grade_sum
FROM grade_info g
left JOIN user u ON g.user_id = u.id
GROUP BY u.id, u.name
ORDER BY grade_sum DESC
LIMIT 1;
查看21道真题和解析