WITH POPUR1520 AS(
    SELECT
        FROM2015.PF_CODE,
        FROM2015.TOTAL_AMT as TA2015,
        FROM2020.TOTAL_AMT as TA2020,
        round(100.0 * FROM2020.TOTAL_AMT / FROM2015.TOTAL_AMT) as RATE
    FROM
        POPU_TRANSITION as FROM2020
        INNER JOIN POPU_TRANSITION as FROM2015 on FROM2020.PF_CODE = FROM2015.PF_CODE
        and FROM2015.SURVEY_YEAR = 2015
    WHERE
        FROM2020.SURVEY_YEAR = 2020
)
SELECT
    P.PF_CODE as 都道府県コード,
    P.PF_NAME as 都道府県名,
    R.TA2015 as 総人口2015年,
    R.TA2020 as 総人口2020年,
    R.RATE as 人口増加率
FROM
    PREFECTURE as P
    INNER JOIN POPUR1520 as R on P.PF_CODE = R.PF_CODE
WHERE
    R.TA2015 < R.TA2020
ORDER BY
    R.RATE DESC,
    P.PF_CODE ASC