SELECT a.DISTRICT_NAME AS 都道府県名 ,a.TOTAL_AMT AS 総人口 FROM POPULATION a WHERE a.LVL = 2 ORDER BY a.TOTAL_AMT DESC