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