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 '%県%') and DISTRICT_NAME not like '%市%';