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