Discuss / SQL / 答案+提问

答案+提问

Topic source

SELECT class_id, AVG(score) AVG_SCORE from students group by class_id;

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

我想知道结果按分数排名怎么查

比如

SELECT class_id, gender, AVG(score) avg_sco FROM students GROUP BY class_id, gender ORDER BY avg_sco DESC;

直接加 ORDER语句

不过从结果来看

![](https://raw.githubusercontent.com/tangg9646/my_github_image_bed/master/20200325163927.png)

还是女生比较厉害啊,哈哈哈

一班和三班男生avg score都比女生高,小伙子


  • 1

Reply