题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select
id,
name,
sum(grade_num) as grade_num
from user u
join grade_info gi
on u.id = gi.user_id
group by id,name
having grade_num = (
select sum(grade_num) as sum
from grade_info
group by user_id
order by sum desc
limit 1 )
order by id
