select
	t1.PF_CODE as 都道府県コード
	, t3.PF_NAME as 都道府県名
	, t1.TOTAL_AMT as 総人口2015年
	, t2.TOTAL_AMT as 総人口2020年
	, ROUND(CAST(t2.TOTAL_AMT as real)/ CAST(t1.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 = 2020
LEFT JOIN PREFECTURE as t3
	on t1.PF_CODE = t3.PF_CODE
WHERE t1.SURVEY_YEAR = 2015
	and t2.TOTAL_AMT > t1.TOTAL_AMT
ORDER BY 5 desc, 1