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
	(
		select
			PF_CODE
			,TOTAL_AMT
		from
			POPU_TRANSITION
		where
			SURVEY_YEAR = 2020
	) as a
	inner join (
		select
			PF_CODE
			,TOTAL_AMT
		from
			POPU_TRANSITION
		where
			SURVEY_YEAR = 2015
  	) as b
		 on a.PF_CODE = b.PF_CODE
	inner join PREFECTURE as p
		 on a.PF_CODE = p.PF_CODE
where
	a.TOTAL_AMT > b.TOTAL_AMT
order by
	5 desc
	,1