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

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

参考了别人的  有点难