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