select gender,university ,count(device_id) 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 gender,university order by gender 要加一个排序才对吧
点赞
牛客网
牛客网在线编程
牛客网题解
牛客企业服务