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
Sign in to make a reply
往事随风Cnof_772
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