答案+提问
Topic source比如
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)
还是女生比较厉害啊,哈哈哈
- 1
二进制爬虫
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;
我想知道结果按分数排名怎么查