– 输出每个班平均分
– 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
05-30
– 输出每个班平均分
– 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