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