with
tb1 as(
select id, name, sum(grade_num) as grade_num from grade_info
left join user on grade_info.user_id = user.id
group by id, name
)
select id, name, grade_num from tb1
where grade_num = (
select max(grade_num) from tb1
)
order by id



京公网安备 11010502036488号