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