select
	PF.PF_CODE as '都道府県コード'
	,PF.PF_NAME as '都道府県名'
	,PF2015.TOTAL_AMT as '総人口2015年'
	,PF2020.TOTAL_AMT as '総人口2020年'
	,ROUND(
		cast(PF2020.TOTAL_AMT as real)*100/cast(PF2015.TOTAL_AMT as real)
		)as '人口増加率'
from
	(select
		 PF_CODE
		,TOTAL_AMT
	from
		POPU_TRANSITION
	where
		SURVEY_YEAR = 2015
	) as PF2015
	,(select
		 PF_CODE
		,TOTAL_AMT
	from
		POPU_TRANSITION
	where
		SURVEY_YEAR = 2020
	) as PF2020
	,PREFECTURE as PF
where
	PF2015.PF_CODE = PF2020.PF_CODE
and	PF2020.PF_CODE = PF.PF_CODE
and PF2020.TOTAL_AMT>=PF2015.TOTAL_AMT
order by
	人口増加率 DESC
	,都道府県コード