作业一:SELECT class_id,avg(score) average FROM students GROUP BY class_id;
作业二:SELECT class_id,gender,avg(score) average FROM students GROUP BY class_id,gender ORDER BY class_id,gender;
Sign in to make a reply
木丶丶心
作业一:SELECT class_id,avg(score) average FROM students GROUP BY class_id;
作业二:SELECT class_id,gender,avg(score) average FROM students GROUP BY class_id,gender ORDER BY class_id,gender;