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