SELECT class_id, AVG(score) average FROM students GROUP BY class_id
SELECT class_id, AVG(score) average ,gender FROM students GROUP BY class_id ,gender
Sign in to make a reply
小丸子别跑
SELECT class_id, AVG(score) average FROM students GROUP BY class_id
SELECT class_id, AVG(score) average ,gender FROM students GROUP BY class_id ,gender