题解 | 分组计算练习题
分组计算练习题
https://www.nowcoder.com/practice/009d8067d2df47fea429afe2e7b9de45
select gender, university, count(*) 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 asc,university asc;
查看9道真题和解析