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