WITH T1 AS (
SELECT
	PF_CODE
,	SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS SUM_2015
,	SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS SUM_2020
FROM
	POPU_TRANSITION
GROUP BY
	PF_CODE
)
SELECT
	T2.PF_CODE AS 都道府県コード
,	T2.PF_NAME AS 都道府県名
,	T1.SUM_2015 AS 総人口2015年
,	T1.SUM_2020 AS 総人口2020年
,	round(cast(T1.SUM_2020 as REAL) / T1.SUM_2015, 2) * 100 AS 人口増加率
FROM
	T1
		INNER JOIN PREFECTURE T2
			ON T1.PF_CODE = T2.PF_CODE
WHERE
	T1.SUM_2020 > T1.SUM_2015
ORDER BY
	5 DESC
,	1 ASC