题解 | 分组排序练习题
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;
相关推荐
kk_km:一看魏家凉皮就知道ip了