SELECT 
	a1.PF_CODE as 都道府県コード,
	b.PF_NAME as 都道府県名,
	a1.TOTAL_AMT as 総人口2015年,
	a2.TOTAL_AMT as 総人口2020年,
	round(a2.TOTAL_AMT * 100.0 / a1.TOTAL_AMT, 0) as 人口増加率
FROM
	(SELECT
		PF_CODE,
		TOTAL_AMT
	FROM
		POPU_TRANSITION
	WHERE
		SURVEY_YEAR = 2015
	) a1,
	(SELECT
		PF_CODE,
		TOTAL_AMT
	FROM
		POPU_TRANSITION
	WHERE
		SURVEY_YEAR = 2020
	) a2,
	PREFECTURE b
WHERE
	a1.PF_CODE = b.PF_CODE AND
	a2.PF_CODE = b.PF_CODE AND
	a1.TOTAL_AMT < a2.TOTAL_AMT
ORDER BY
	人口増加率 DESC,
	都道府県コード ASC