SELECT
	T15.PF_CODE AS 都道府県コード,
	P.PF_NAME AS 都道府県名,
	T15.TOTAL_AMT AS 総人口2015年,
	T20.TOTAL_AMT AS 総人口2020年,
	ROUND(CAST(T20.TOTAL_AMT AS REAL) / CAST(T15.TOTAL_AMT AS REAL) * 100) AS 人口増加率
FROM
	POPU_TRANSITION T15
	INNER JOIN POPU_TRANSITION T20
	ON T15.PF_CODE = T20.PF_CODE
	INNER JOIN PREFECTURE P
	ON T15.PF_CODE = P.PF_CODE
WHERE
	T15.SURVEY_YEAR = 2015 
AND T20.SURVEY_YEAR = 2020
AND	T15.TOTAL_AMT < T20.TOTAL_AMT
ORDER BY
	人口増加率 DESC,
	都道府県コード
;