select
    DISTRICT_NAME as "都道府県名"
    ,SUM(TOTAL_AMT) as "総人口"
from
    POPULATION
where
    LVL==2
group by
    DISTRICT_NAME
order by
    "総人口" DESC
;