Discuss / SQL / 作业
Back

作业

Topic source

NahuyeuY

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

第一题：

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

第二题：

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

  • 1

Reply