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