题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
WITH temp_table AS (
SELECT u1.id, u1.name, SUM(g.grade_num) AS grade_num
FROM user u1
JOIN grade_info g ON u1.id = g.user_id
GROUP BY u1.id, u1.name
)
SELECT id, name, grade_num
FROM temp_table
WHERE grade_num = (
SELECT MAX(grade_num)
FROM temp_table
);
查看14道真题和解析