select DISTRICT_NAME as '都道府県名', TOTAL_AMT as '総人口'
from POPULATION
where DISTRICT_NAME <> '全国'
order by '総人口' desc