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

select gender,university,count(gender) as user_num,round(avg(active_days_within_30),1),round(avg(question_cnt),1)
from user_profile
group by gender,university