题解 | #每个年龄的学生在各学校最大数量#
每个年龄的学生在各学校最大数量
https://www.nowcoder.com/practice/8a2a416d26144c93b67e26581764d8ab
select age,max(cnt) as max_cnt from (select age,university,count(id) as cnt from user_profile group by age,university) as tmp group by age order by max_cnt desc
#MySQL#
查看4道真题和解析
，这个代码不商用是没问题的