select DISTRICT_NAME AS 都道府県名, TOTAL_AMT as 総人口 from POPULATION where LVL = 2 ORDER BY TOTAL_AMT DESC