WITH year2015 AS(
 SELECT PF_CODE, TOTAL_AMT AS TOTAL_AMT_2015
 FROM POPU_TRANSITION
 WHERE SURVEY_YEAR = 2015
),
year2020 AS(
 SELECT PF_CODE, TOTAL_AMT AS TOTAL_AMT_2020
 FROM POPU_TRANSITION
 WHERE SURVEY_YEAR = 2020
)
SELECT DISTINCT
        PRE.PF_CODE AS 都道府県コード,
        PRE.PF_NAME AS 都道府県名,
        TOTAL_AMT_2015 AS 総人口2015年,
        TOTAL_AMT_2020 AS 総人口2020年,
        ROUND(CAST(TOTAL_AMT_2020 AS float) * 100 / TOTAL_AMT_2015, 0) AS 人口増加率
FROM POPU_TRANSITION AS POP
    JOIN PREFECTURE AS PRE
        ON POP.PF_CODE = PRE.PF_CODE
    JOIN year2015
        ON POP.PF_CODE = year2015.PF_CODE
    JOIN year2020
        ON POP.PF_CODE = year2020.PF_CODE
WHERE 人口増加率 > 100
ORDER BY 人口増加率 DESC, 都道府県コード ASC;