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