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