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