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