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;