select DISTRICT_NAME 都道府県名,TOTAL_AMT 総人口
from population
where district_name like "%県" or
       district_name like "%府"or
       district_name like "%道";