select
DISTRICT_NAME 都道府県名 ,
sum(TOTAL_AMT) 総人口
from POPULATION 
WHERE LVL=2
group by DISTRICT_NAME
order by TOTAL_AMT DESC