代码 SELECT a.class,e.course,avg(score) from account a,exam e where a.id =e.aid group by e.course,a.class 结果