Discuss / SQL / 练习
Back

练习

Topic source

陈遁·木琴剥离

#1 Created at ... [Delete] [Delete and Lock User] 
#查询每个班级的平均分
SELECT class_id,avg(score)
FROM students
GROUP BY class_id;

#查询每个班级男生和女生的平均分
SELECT class_id,gender,avg(score)
FROM students
GROUP BY class_id,gender;
  • 1

Reply