WITH RECURSIVE data_2015 AS (
    SELECT PF_CODE
        ,TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015
),data_2020 AS(
    SELECT PF_CODE
        ,TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020
)
SELECT 
    data_2015.PF_CODE AS 都道府県コード
    ,PREFECTURE.PF_NAME  AS 都道府県名
    , data_2015.TOTAL_AMT  AS 総人口2015年
    , data_2020.TOTAL_AMT  AS 総人口2020年
    ,ROUND(CAST(data_2020.TOTAL_AMT AS real) / CAST(data_2015.TOTAL_AMT AS real) * 100) AS 人口増加率
FROM data_2015
LEFT JOIN data_2020 ON data_2015.PF_CODE = data_2020.PF_CODE
LEFT JOIN PREFECTURE ON data_2015.PF_CODE = PREFECTURE.PF_CODE     
WHERE data_2015.TOTAL_AMT < data_2020.TOTAL_AMT
ORDER BY
    人口増加率 DESC
    ,都道府県コード ASC;