SELECT
    POPU_TRANSITION_2015.PF_CODE AS '都道府県コード',
    PREFECTURE.PF_NAME AS '都道府県名',
    POPU_TRANSITION_2015.TOTAL_AMT AS '総人口2015年',
    POPU_TRANSITION_2020.TOTAL_AMT AS '総人口2020年',
    ROUND(CAST(POPU_TRANSITION_2020.TOTAL_AMT AS REAL) / CAST(POPU_TRANSITION_2015.TOTAL_AMT AS REAL) * 100) AS '人口増加率'
FROM
    (
        SELECT
            PF_CODE,
            TOTAL_AMT
        FROM
            POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2015
    ) AS POPU_TRANSITION_2015
INNER JOIN
    (
        SELECT
            PF_CODE,
            TOTAL_AMT
        FROM
            POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2020
    ) AS POPU_TRANSITION_2020
ON
    POPU_TRANSITION_2015.PF_CODE = POPU_TRANSITION_2020.PF_CODE
INNER JOIN
    PREFECTURE AS PREFECTURE
ON
    POPU_TRANSITION_2015.PF_CODE = PREFECTURE.PF_CODE
ORDER BY
    人口増加率 DESC, 都道府県コード ASC;