SQL code: select a.className,c.scoreName, avg(score) as 平均分,sum(score) as 总分, max(score) as 最高分, 最高分学生姓名=(select name from tb t where score=(select max(score) from T_Score t where name=t.name), min(score) as 最低分, 最高分学生姓名=(select name from tb t where score=(select min(score) from T_Score t where name=t.name) from T_Class a,T_Student b,T_Score c where a.classID=b.classID and b.studentID=c.studentID group by a.className,c.scoreName
