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