WITH POPU_2015 AS (
    SELECT PF_CODE, TOTAL_AMT AS TOTAL_AMT_2015
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015
),
POPU_2020 AS (
    SELECT PF_CODE, TOTAL_AMT AS TOTAL_AMT_2020
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020
)
SELECT A.PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    TOTAL_AMT_2015 AS 総人口2015年,
    TOTAL_AMT_2020 AS 総人口2020年,
    ROUND(100.0 * TOTAL_AMT_2020 / TOTAL_AMT_2015) AS 人口増加率
FROM POPU_2015 AS A 
    INNER JOIN POPU_2020 AS B ON A.PF_CODE = B.PF_CODE
    INNER JOIN PREFECTURE AS P ON A.PF_CODE = P.PF_CODE
WHERE 人口増加率 >= 100
ORDER BY 人口増加率 DESC, 都道府県コード