WITH TOTAL_AMT_2015_T AS(
    SELECT
        PF_CODE
        , TOTAL_AMT AS TOTAL_AMT_2015
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2015
), TOTAL_AMT_2020_T AS(
    SELECT
        PF_CODE
        , TOTAL_AMT AS TOTAL_AMT_2020
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2020
)
SELECT
    T.PF_CODE AS 都道府県コード
    , PF_NAME AS 都道府県名
    , TOTAL_AMT_2015 AS 総人口2015年
    , TOTAL_AMT_2020 AS 総人口2020年
    , ROUND((CAST(TOTAL_AMT_2020 AS REAL)/CAST(TOTAL_AMT_2015 AS REAL))*100) AS 人口増加率
FROM
    TOTAL_AMT_2015_T T
    INNER JOIN TOTAL_AMT_2020_T USING(PF_CODE)
    INNER JOIN PREFECTURE USING(PF_CODE)
WHERE
    TOTAL_AMT_2020 > TOTAL_AMT_2015
ORDER BY 5 DESC, 1