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