Q1

SELECT class_id, COUNT(*) num, AVG(score) avg_score FROM students GROUP BY class_id;

Q2

SELECT class_id, gender, COUNT(*) num, AVG(score) avg_score FROM students GROUP BY class_id, gender;