WITH T2015 AS(
SELECT
    PR.PF_CODE,
    PR.PF_NAME,
    PO.TOTAL_AMT
FROM
    POPU_TRANSITION PO
LEFT JOIN
    PREFECTURE PR
ON
    PO.PF_CODE = PR.PF_CODE
WHERE
    PO.SURVEY_YEAR = 2015
), T2020 AS(
SELECT
    PR.PF_CODE,
    PR.PF_NAME,
    PO.TOTAL_AMT
FROM
    POPU_TRANSITION PO
LEFT JOIN
    PREFECTURE PR
ON
    PO.PF_CODE = PR.PF_CODE
WHERE
    PO.SURVEY_YEAR = 2020
)
SELECT
    T2015.PF_CODE AS '都道府県コード',
    T2015.PF_NAME AS '都道府県名',
    T2015.TOTAL_AMT AS '総人口2015年',
    T2020.TOTAL_AMT AS '総人口2020年',
    ROUND(100.0 * T2020.TOTAL_AMT / T2015.TOTAL_AMT) AS '人口増加率'
FROM T2015
INNER JOIN
    T2020
ON
    T2015.PF_CODE = T2020.PF_CODE
WHERE
    ROUND(100.0 * T2020.TOTAL_AMT / T2015.TOTAL_AMT) > 100
ORDER BY 5 DESC;