题解 | #分组过滤练习题#
分组过滤练习题
https://www.nowcoder.com/practice/ddbcedcd9600403296038ee44a172f2d
select t1.university,avg_question_cnt,avg_answer_cnt
from
(
select university, avg(question_cnt) as avg_question_cnt
from user_profile
group by university)t1
join
(
select university, avg(answer_cnt) as avg_answer_cnt
from user_profile
group by university
)t2
on t1.university=t2.university
where avg_question_cnt<5 or avg_answer_cnt<20
查看16道真题和解析
