SELECT
    pt.PF_CODE AS 都道府県コード
    ,p.PF_NAME AS 都道府県名
    ,pt.TOTAL_AMT AS 総人口2015年
    ,pt2020.TOTAL_AMT AS 総人口2020年
    ,ROUND(CAST(pt2020.TOTAL_AMT AS float) / CAST(pt.TOTAL_AMT AS float) * 100, 0) AS 人口増加率
FROM
    POPU_TRANSITION AS pt
JOIN
    PREFECTURE AS p
ON
    pt.PF_CODE = p.PF_CODE
JOIN
    (SELECT
        PF_CODE
        ,TOTAL_AMT
     FROM
        POPU_TRANSITION
     WHERE
        SURVEY_YEAR = 2020) AS pt2020
ON
    pt.PF_CODE = pt2020.PF_CODE
WHERE
    SURVEY_YEAR = 2015
ORDER BY
    人口増加率 DESC
    ,都道府県コード;