SELECT
DISTRICT_NAME AS "都道府県名",
sum(TOTAL_AMT) AS "総人口"

FROM POPULATION

WHERE
LVL = 2

GROUP BY 1
ORDER BY 2 desc