每个班的各学科平均分 select a.class,e.course,AVG(e.score) from account as a , exam as e where a.id = e.aid GROUP BY a.class,e.course