Discuss / SQL / 1111

--计算每个班级的平均分 SELECT class_id, AVG(score) point FROM students GROUP BY class_id;

--请使用一条SELECT查询查出每个班级男生和女生的平均分: SELECT class_id,gender, AVG(score) point FROM students GROUP BY class_id,gender;


  • 1

Reply