SELECT gender,university,COUNT(gender),avg(active_days_within_30),avg(question_cnt) FROM user_profile group BY gender,university;
对性别和学校两个维度来分组统计
SELECT gender,university,COUNT(gender),avg(active_days_within_30),avg(question_cnt) FROM user_profile group BY gender,university;
对性别和学校两个维度来分组统计