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