题解 | #分组排序练习题#

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

先分组

后排序