Discuss / SQL / 交作业

交作业

Topic source

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;


  • 1

Reply