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