select DISTRICT_NAME AS 都道府県名 ,TOTAL_AMT AS 総人口 From POPULATION where LVL = 2 ORder BY TOTAL_AMT DESC