select gender,university, COUNT(device_id) as user_num,avg(active_days_within_30),avg(question_cnt) 
from  user_profile 
group BY university,gender