select DISTRICT_NAME "都道府県名",TOTAL_AMT "総人口"
from POPULATION
WHERE DISTRICT_NAME<>"全国"
order by TOTAL_AMT DESC