题解 | #分组过滤练习题#
分组过滤练习题
http://www.nowcoder.com/practice/ddbcedcd9600403296038ee44a172f2d
SELECT
university,
avg(question_cnt),
avg(answer_cnt)
from user_profile
group by university
having avg(question_cnt)<5
or
avg(answer_cnt)<20
考点group by having
按照大学进行分组 group by university,条件having avg(question_cnt)<5 or avg(answer_cnt)<20