WITH 
stat2015 AS (
    SELECT
        pop.PF_CODE
        , pop.TOTAL_AMT AS tot2015
    FROM
        POPU_TRANSITION pop
    WHERE
        SURVEY_YEAR = 2015
    ),
    
stat2020 AS (
    SELECT
        pop.PF_CODE
        , pop.TOTAL_AMT AS tot2020
    FROM
        POPU_TRANSITION pop
    WHERE
        SURVEY_YEAR = 2020
    )

SELECT
    pref.PF_CODE AS 都道府県コード
    , pref.PF_NAME AS 都道府県名
    , stat2015.tot2015 AS 総人口2015年
    , stat2020.tot2020 AS 総人口2020年
    , ROUND(100.0 * stat2020.tot2020 / stat2015.tot2015, 0) AS 人口増加率
FROM
    PREFECTURE pref
    
    LEFT JOIN
        stat2015 ON pref.PF_CODE = stat2015.PF_CODE
        
    LEFT JOIN
        stat2020 ON pref.PF_CODE = stat2020.PF_CODE
    
ORDER BY
    人口増加率 DESC
    , 都道府県コード