SELECT DISTRICT_NAME AS '都道府県名',TOTAL_AMT AS '総人口'

FROM POPULATION

WHERE LVL = '2'

ORDER BY TOTAL_AMT DESC;