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