WITH s AS (
SELECT
    PF_CODE,
    TOTAL_AMT
FROM
    POPU_TRANSITION
WHERE
    SURVEY_YEAR = 2015
)
, e AS (
SELECT
    PF_CODE,
    TOTAL_AMT
FROM
    POPU_TRANSITION
WHERE
    SURVEY_YEAR = 2020
)

SELECT
    s.PF_CODE AS 都道府県コード
    , e.PF_CODE AS 都道府県名
    , s.TOTAL_AMT AS 総人口2015年
    , s.TOTAL_AMT AS 総人口2020年
    , ROUND(e.TOTAL_AMT * 100.0 / s.TOTAL_AMT, 1) AS 人口増加率
FROM
    s
    INNER JOIN e using(PF_CODE)
    INNER JOIN PREFECTURE using(PF_CODE)
ORDER BY
    人口増加率 DESC, PF_CODE