计算每个人的总成绩并排名selectCourseID,sum(Score)asallscorefromScoreInformationgroupbyCourseIDorderbyallscore