1.查个班的平均分:
SELECT class_id ,AVG(score) FROM students GROUP BY class_id;
2.查个班男女的平均分:
SELECT class_id, gender,AVG(score) FROM students GROUP BY class_id, gender;
Sign in to make a reply
贝克街的Noc
1.查个班的平均分:
SELECT class_id ,AVG(score) FROM students GROUP BY class_id;
2.查个班男女的平均分:
SELECT class_id, gender,AVG(score) FROM students GROUP BY class_id, gender;