题解 | #分组排序练习题#
分组排序练习题
https://www.nowcoder.com/practice/e00bbac732cb4b6bbc62a52b930cb15e
SELECT university,
ROUND(AVG(question_cnt),4) AS avg_question_cnt
FROM user_profile
GROUP BY university
ORDER BY avg_question_cnt;
分组排序练习题
https://www.nowcoder.com/practice/e00bbac732cb4b6bbc62a52b930cb15e
SELECT university,
ROUND(AVG(question_cnt),4) AS avg_question_cnt
FROM user_profile
GROUP BY university
ORDER BY avg_question_cnt;
相关推荐
牛客41406533...:回答他在课上学,一辈子待在学校的老教授用三十年前的祖传PPT一字一句的讲解,使用谭浩强红皮书作为教材在devc++里面敲出a+++++a的瞬间爆出114514个编译错误来学