select distinct
gender ,
university ,
count(id) over (partition by gender,university) as user_num ,
round(avg(active_days_within_30) over (partition by gender,university) ,1) as avg_active_day ,
round(avg(question_cnt) over (partition by gender,university) ,1) as avg_question_cnt
from user_profile 
order by gender ,university