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