SELECT DISTRICT_NAME AS "都道府県名" , SUM(TOTAL_AMT) AS "総人口" FROM POPULATION WHERE LVL = 2 GROUP BY DISTRICT_NAME ORDER BY "総人口" DESC