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