select DISTRICT_NAME 都道府県名
, TOTAL_AMT 総人口
from POPULATION
where 
LVL =2
group by DISTRICT_NAME
order by TOTAL_AMT desc