Discuss / SQL / 交作业啦交作业啦,其实很简单的

交作业啦交作业啦,其实很简单的

Topic source

分别是作业一和作业二

SELECT class_id,avg(score)  from students group by class_id;
SELECT class_id,gender,avg(score) from students group by class_id,gender;


  • 1

Reply