题解 | 分组计算练习题
分组计算练习题
https://www.nowcoder.com/practice/009d8067d2df47fea429afe2e7b9de45
select
gender,university,count(device_id) as 'user_num',
avg(active_days_within_30) as 'avg_active_day',
avg(question_cnt) as 'avg_question_cnt'
from user_profile
group by gender,university
order by gender;
题目要求：1.需要对性别和学校进行分组
2. 查询出来的结果按照gender升序排列
所以用到的关键字：聚合函数，分组group by 和 order by
投递美团等公司7个岗位 >
查看11道真题和解析