select
 DISTRICT_NAME as 都道府県名 ,
 TOTAL_AMT as 総人口
 from POPULATION
 where LVL = 2
 group by 都道府県名
 order by 総人口 desc