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

# class_id gender socre

1 M 89.0000

1 F 84.0000

2 F 81.0000

2 M 70.0000

3 F 88.0000

3 M 89.0000