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