题解 | #分组计算练习题#

select gender,
       university,
       count(*)                   as "user_num",
       avg(active_days_within_30) as "avg_active_day",
       avg(question_cnt)          as "avg_question_cnt"
from user_profile
group by gender, university