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