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