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
    TOTAL_AMT_2020 > TOTAL_AMT_2015
ORDER BY
    人口増加率 DESC
    , 都道府県コード
;