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