select
	t1.PF_CODE as 都道府県コード
	,PF_NAME as 都道府県名
	,t2.TOTAL_AMT as 総人口2015年
	,t1.TOTAL_AMT as 総人口2020年
	,round(cast(t1.TOTAL_AMT as real) / cast(t2.TOTAL_AMT as real) * 100,0) as 人口増加率
from POPU_TRANSITION as t1
inner join POPU_TRANSITION as t2
	on t1.PF_CODE = t2.PF_CODE
	and t2.SURVEY_YEAR = 2015
inner join PREFECTURE as t3
	on t1.PF_CODE = t3.PF_CODE
where
	t1.SURVEY_YEAR = 2020
	and 人口増加率 > 100
order by
	人口増加率 desc
	,t1.PF_CODE