select gender,university,count(id) as user_num, AVG(active_days_within_30) as avg_active_day, AVG(question_cnt) as avg_question_cnt 
from user_profile
group by university,gender;