Discuss / SQL / 作业
Back

作业

Topic source

祎带一路

#1 Created at ... [Delete] [Delete and Lock User]

//1

-- SELECT * from students;

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;

  • 1

Reply