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