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