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