select 
 district_name AS 都道府県名, 
 sum(male_amt + female_amt) as 総人口 
from population 
where lvl = 2 
group by district_name
order by 総人口 DESC