Select a.class,b.subject,avg(b.score) from score b join student a on a.id =b.student.id group by a.class,b.subject;
5、表student(id,class,name)Score (student_id,score,subject)求每个班各科平均分
最新推荐文章于 2024-10-13 21:08:42 发布
Select a.class,b.subject,avg(b.score) from score b join student a on a.id =b.student.id group by a.class,b.subject;