作业1&2

Discuss / SQL / 作业1&2

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 gender, class_id;