SELECT gender,university,COUNT(*) user_num,
       round(avg(active_days_within_30),1) AS avg_active_day,
       ROUND(avg(question_cnt),1) AS avg_question_cnt
FROM user_profile
GROUP BY gender,university;