select DISTRICT_NAME as 都道府県名 , sum(TOTAL_AMT) as 総人口 from
POPULATION
where DISTRICT_NAME like '%県'
or DISTRICT_NAME like '%都'
or DISTRICT_NAME like '%道'
or DISTRICT_NAME like '%府'
group by DISTRICT_NAME
order by 総人口 desc;