一、SELECT class_id, AVG(score) avgscore FROM students GROUP BY class_id;
二、SELECT class_id, gender, AVG(score) avgscore FROM students GROUP BY class_id, gender;
Sign in to make a reply
玛格诺力呀
一、SELECT class_id, AVG(score) avgscore FROM students GROUP BY class_id;
二、SELECT class_id, gender, AVG(score) avgscore FROM students GROUP BY class_id, gender;