第一题

SELECT class_id [班级],AVG(score) [平均分] FROM students GROUP BY class_id

第二题

SELECT class_id [班级], gender [性别],AVG(score) [平均分] FROM students GROUP BY class_id,gender