# 先对大学分组,分完组之后,查询平均发帖,查询之后,排序即可 # SQL执行顺序, from > group by > select > order by select university, avg(question_cnt) as avg_question_cnt from user_profile group by university order by avg_question_cnt asc