题解 | #分组排序练习题#
分组排序练习题
https://www.nowcoder.com/practice/e00bbac732cb4b6bbc62a52b930cb15e
SELECT A.university,A.avg_question_cnt FROM (SELECT university,AVG(question_cnt)AS avg_question_cnt FROM user_profile GROUP BY university)A ORDER BY A.avg_question_cnt