题解 | 分组排序练习题

select university,avg(question_cnt) as avg_question_cnt
from user_profile
group by university
order by avg_question_cnt;

select university,avg(question_cnt) as avg_question_cnt

from user_profile

group by university /按学校字段进行分组

order by avg_question_cnt; /按平均发帖数列 avg_question_cnt 进行升序排列