SELECT class_id,gender,count(score),avg(score) average FROM students GROUP BY class_id ,gender
Sign in to make a reply
制宪会议
SELECT class_id,gender,count(score),avg(score) average FROM students GROUP BY class_id ,gender