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