select
    district_name as "都道府県名",
    sum(total_amt) as "総人口"
from
    population
where
    lvl = 2
group by
    district_name
order by
    sum(total_amt) desc
;