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