题解 | #每个年龄的学生在各学校最大数量#
每个年龄的学生在各学校最大数量
https://www.nowcoder.com/practice/8a2a416d26144c93b67e26581764d8ab
select distinct t.age, t.max_cnt from( select age, count(id) as max_cnt, dense_rank()over(partition by age order by count(id) desc) as pt from user_profile group by age,university ) as t where t.pt=1 order by max_cnt desc,t.age desc