SELECT class_id, gender, ROUND(AVG(score), 2) avg_score FROM students GROUP BY class_id, gender ORDER BY class_id, gender;
Sign in to make a reply
五点三十七
SELECT class_id, gender, ROUND(AVG(score), 2) avg_score FROM students GROUP BY class_id, gender ORDER BY class_id, gender;