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