SELECT	pr1.PF_CODE AS 都道府県コード,
		pr1.PF_NAME AS 都道府県名,
		(
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt1
		WHERE	SURVEY_YEAR = 2015 AND pr1.PF_CODE = pt1.PF_CODE
		) AS 総人口2015年,
		(
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt2
		WHERE	SURVEY_YEAR = 2020 AND pr1.PF_CODE = pt2.PF_CODE
		) AS 総人口2020年,
		round(cast((
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt3
		WHERE	SURVEY_YEAR = 2020 AND pr1.PF_CODE = pt3.PF_CODE
		) as double) / (
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt4
		WHERE	SURVEY_YEAR = 2015 AND pr1.PF_CODE = pt4.PF_CODE
		) * 100 ) AS 人口増加率
		
FROM	PREFECTURE AS pr1
WHERE   round(cast((
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt3
		WHERE	SURVEY_YEAR = 2020 AND pr1.PF_CODE = pt3.PF_CODE
		) as double) / (
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt4
		WHERE	SURVEY_YEAR = 2015 AND pr1.PF_CODE = pt4.PF_CODE
		) * 100 ) >= 100
ORDER BY round(cast((
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt3
		WHERE	SURVEY_YEAR = 2020 AND pr1.PF_CODE = pt3.PF_CODE
		) as double) / (
		SELECT	TOTAL_AMT
		FROM	POPU_TRANSITION AS pt4
		WHERE	SURVEY_YEAR = 2015 AND pr1.PF_CODE = pt4.PF_CODE
		) * 100 ) DESC, pr1.PF_CODE