SELECT
    PRE.PF_CODE       AS 都道府県コード,
    PRE.PF_NAME       AS 都道府県名,
    POP.TOTAL_AMT     AS 総人口2015年,
    POP2020.TOTAL_AMT AS 総人口2020年,
    ROUND(
        CAST(POP2020.TOTAL_AMT AS REAL) / CAST(POP.TOTAL_AMT AS REAL) * 100
    ) AS 人口増加率
FROM
    POPU_TRANSITION AS POP,
    PREFECTURE      AS PRE
        ON POP.PF_CODE = PRE.PF_CODE
    INNER JOIN POPU_TRANSITION AS POP2020 -- 比較用に2020で絞り込み
        ON POP2020.PF_CODE = POP.PF_CODE
        AND POP2020.SURVEY_YEAR = 2020
WHERE
    POP.SURVEY_YEAR = 2015 AND POP2020.TOTAL_AMT >= POP.TOTAL_AMT
ORDER BY
    人口増加率 DESC,
    都道府県コード ASC;