select
 DISTRICT_NAME AS '都道府県名'
,SUM(TOTAL_AMT) AS '総人口'
from POPULATION
where LVL=2
order by TOTAL_AMT desc;