select b.name，a.sumscore from(select 学生 id，sum(score)as sumscore from score where sumscore>500)a join student b on a.学生id=b.学生id