考试成绩的多表联查

 

 

 

 

 

 

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