select
DISTRICT_NAME as "都道府県名", TOTAL_AMT as "総人口"
from
POPULATION
where "都道府県名" != "全国"
ORDER BY
TOTAL_AMT desc