SELECT DISTRICT_NAME as 都道府県名,
        TOTAL_AMT as 総人口
FROM    POPULATION
WHERE   DISTRICT_NAME != "全国"
ORDER BY TOTAL_AMT DESC;