SELECT class_id, gender, AVG(score) FROM students GROUP BY class_id, gender ORDER BY class_id, gender;
Sign in to make a reply
zado.
SELECT class_id, gender, AVG(score) FROM students GROUP BY class_id, gender ORDER BY class_id, gender;