SELECT DISTRICT_NAME AS 都道府県名 ,TOTAL_AMT AS 総人口 FROM POPULATION WHERE LVL = 2 GROUP BY 1 ORDER BY 2 DESC;