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