Discuss / SQL / 作业
Back

作业

Topic source

阳光帅气的Jack

#1 Created at ... [Delete] [Delete and Lock User]

1.查询查出每个班级的平均分： SELECT class_id,AVG(score) AS average FROM students GROUP BY class_id; 2.查询每个班级男生和女生的平均分 SELECT class_id,gender,AVG(score) AS average FROM students GROUP BY class_id;

阳光帅气的Jack

#2 Created at ... [Delete] [Delete and Lock User]

作业二修正：SELECT class_id,gender,AVG(score) AS average FROM students GROUP BY class_id，gender;

  • 1

Reply