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