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