#找到了id跟总分
select b.name,a.add0
from
(
#add
select user_id,sum(grade_num) add0
from grade_info
where type='add'
group by user_id
) a left join user b
on a.user_id=b.id
order by a.add0 desc
limit 1
;

京公网安备 11010502036488号