Discuss - 廖雪峰的官方网站

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;