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