Discuss / SQL / 2222

select class_id '班级',avg(score) '平均分' from students group by class_id;

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


  • 1

Reply