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