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