select c.name class_name,s.gender,avg(s.score) avg_score from students s,classes c where s.class_id=c.id group by class_id,s.gender;
Sign in to make a reply
ICsd阿布
select c.name class_name,s.gender,avg(s.score) avg_score from students s,classes c where s.class_id=c.id group by class_id,s.gender;