select DISTRICT_NAME '都道府県名', SUM(TOTAL_AMT) '総人口' from POPULATION where LVL = 2 GROUP BY DISTRICT_NAME;