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 都道府県コード
    , p.PF_NAME AS 都道府県名
    , s.TOTAL_AMT AS 総人口2015年
    , e.TOTAL_AMT AS 総人口2020年
    , ROUND(e.TOTAL_AMT * 100.0 / s.TOTAL_AMT, 0) AS 人口増加率
FROM
    s
    JOIN e using(PF_CODE)
    JOIN PREFECTURE p using(PF_CODE)
WHERE
    e.TOTAL_AMT > s.TOTAL_AMT
ORDER BY
    人口増加率 DESC, PF_CODE