select
    PO.PF_CODE as 都道府県コード
    , PF_NAME as 都道府県名
    , po.TOTAL_AMT as 総人口2015
    , po2020.TOTAL_AMT as 総人口2020
    , ROUND(
        CAST(po2020.TOTAL_AMT as REAL) / CAST(PO.TOTAL_AMT as REAL) * 100
    ) AS 人口増加率
from
    POPU_TRANSITION as PO
    inner join
        PREFECTURE as pf
    ON
        pf.PF_CODE = PO.PF_CODE
    AND
        PO.SURVEY_YEAR = 2015
    inner join
        POPU_TRANSITION as po2020
    ON
        po2020.PF_CODE = PO.PF_CODE
    AND
        po2020.SURVEY_YEAR = 2020
WHERE
    po2020.TOTAL_AMT > PO.TOTAL_AMT
ORDER BY
    人口増加率 desc
    , 都道府県コード asc;