运营想查看不同大学情况,就用大学分组 group by university查看用户平均发帖情况,avg( question_cnt)升序排列 group by university order by avg_question_cnt asc总结得出:select university , avg( question_cnt) as avg_question_cntfrom user_profilegroup by university order by avg_question_cnt asc