SELECT
    POPU1.PF_CODE AS 都道府県コード
    , PF_NAME AS 都道府県名
    , TOTAL_AMT_2015 AS 総人口2015年
    , TOTAL_AMT_2020 AS 総人口2020年
    , ROUND(100 * CAST(TOTAL_AMT_2020 AS REAL) / TOTAL_AMT_2015) AS 人口増加率
FROM
    (
        SELECT
            TOTAL_AMT AS TOTAL_AMT_2015
            , PF_CODE
        FROM
            POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2015
    ) AS POPU1
    LEFT OUTER JOIN
        (
            SELECT
                TOTAL_AMT AS TOTAL_AMT_2020
                , PF_CODE
            FROM
                POPU_TRANSITION
            WHERE
                SURVEY_YEAR = 2020
        ) AS POPU2
        ON POPU1.PF_CODE = POPU2.PF_CODE
    LEFT OUTER JOIN PREFECTURE AS PREF
        ON POPU1.PF_CODE = PREF.PF_CODE
WHERE
    人口増加率 > 100
ORDER BY
    人口増加率 DESC
    , 都道府県コード
;