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