题解 | 分组排序练习题

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

order by 后面可以使用别名，因为 order by执行顺序在 select之后。