SELECT  gender,  university,  COUNT(university) as 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  university, gender; 按照大...