WITH tbl_15 AS (
    SELECT
        SURVEY_YEAR,
        PF_CODE,
        TOTAL_AMT AS amt_15
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2015
),
tbl_20 AS (
    SELECT
        SURVEY_YEAR,
        PF_CODE,
        TOTAL_AMT AS amt_20
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2020
)
SELECT
    p.PF_CODE  AS '都道府県コード',
    p.PF_NAME AS '都道府県名',
    t1.amt_15 AS '総人口2015年',
    t2.amt_20 AS '総人口2020年',
    ROUND(100 + (t2.amt_20 - t1.amt_15) * 100. / t1.amt_15) AS '人口増加率'
FROM
    PREFECTURE AS p
LEFT JOIN
    tbl_15 as t1
    ON p.PF_CODE = t1.PF_CODE
LEFT JOIN
    tbl_20 as t2
    ON p.PF_CODE = t2.PF_CODE
WHERE
    人口増加率 > 100
ORDER BY
    人口増加率 DESC,
    都道府県コード ASC
;