题解 | 获得积分最多的人(一)
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
select
t.name,
t.grade_num
from
(select
u.name as name,
sum(g.grade_num) as grade_num
from
user u
right join
grade_info g
on
u.id=g.user_id
where
g.type = 'add'
group by
u.name) t
order by
t.grade_num desc
limit 1
