Discuss / SQL / 交作业
Back

交作业

Topic source

用户06lgllpdgh

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

SELECT class_id, AVG(score) average FROM students GROUP BY class_id;

SELECT class_id,gender sex,AVG(score) average FROM students GROUP BY class_id,gender;

  • 1

Reply