题解 | #每个年龄的学生在各学校最大数量#
每个年龄的学生在各学校最大数量
https://www.nowcoder.com/practice/8a2a416d26144c93b67e26581764d8ab
select age,max(max_cnt) max_cnt
from (
select distinct age,count(*) max_cnt
from user_profile
group by age,university
order by max_cnt desc
) a
group by age
order by max_cnt desc,age desc
查看17道真题和解析