作业1: select class_id, avg(score) average from students group by class_id
作业2: select class_id, gender, avg(score) average from students group by class_id, gender
Sign in to make a reply
-blingbling酱-
作业1: select class_id, avg(score) average from students group by class_id
作业2: select class_id, gender, avg(score) average from students group by class_id, gender