select DISTRICT_NAME as '都道府県名', sum(TOTAL_AMT) as '総人口' from POPULATION
where LVL = 2
group by DISTRICT_NAME
order by DISTRICT_CODE