SELECT gender,university,COUNT(gender),avg(active_days_within_30)as avg_active_days,
avg(question_cnt)as question_cnt from user_profile
GROUP by gender,university
SELECT gender,university,COUNT(gender),avg(active_days_within_30)as avg_active_days,
avg(question_cnt)as question_cnt from user_profile
GROUP by gender,university