九州体育网 - 十年信誉网站

关于作者

Discuss / SQL / 答题

答题

Topic source

大话噼里啪啦

#1 Created at ...

~每个班级平均分 SELECT class_id, avg(score) pingjunfen FROM students GROUP BY class_id;

~每个班级男生和女生平均分 select class_id, avg(score)pingjunfen, gender from students group by class_id, gender;


  • 1

Reply

WARNING: You are using an old browser that does not support HTML5. Please choose a modern browser (Chrome / Microsoft Edge / Firefox / Sarafi) to get a good experience.