题目如下:
题解如下:
select age,max(cnt) max_cnt
from(
select age,count(device_id) cnt
from user_profile
group by age,university
) a
group by age
order by max_cnt desc
题目如下:
题解如下:
select age,max(cnt) max_cnt
from(
select age,count(device_id) cnt
from user_profile
group by age,university
) a
group by age
order by max_cnt desc