SELECT class_id,COUNT(*) num,AVG(score) FROM students GROUP BY class_id,gender;
Sign in to make a reply
慈溪迦南
SELECT class_id,COUNT(*) num,AVG(score) FROM students GROUP BY class_id,gender;