select DISTRICT_NAME as "都道府県名", TOTAL_AMT as "総人口" from POPULATION; select * from POPULATION order by TOTAL_AMT desc;