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