select DISTRICT_NAME as '都道府県名', TOTAL_AMT as '総人口' 
from population where DISTRICT_NAME like '%都' 
or DISTRICT_NAME like '%道' or DISTRICT_NAME like '%府' or DISTRICT_NAME like'%県'
order by TOTAL_AMT DESC;