Discuss / SQL / 作业
Back

作业

Topic source

千城忆梦

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

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

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

  • 1

Reply