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

FROM POPULATION

WHERE LVL=2

ORDER BY TOTAL_AMT DESC;