SELECT
    PO.PF_CODE as "都道府県コード"
    , PR.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
        ,0
    ) as "人口増加率"
FROM
    POPU_TRANSITION as PO
    INNER JOIN PREFECTURE as PR
        ON PR.PF_CODE = PO.PF_CODE
    INNER JOIN POPU_TRANSITION as PO2020
        -- 2020年の人口データ
        ON PO.PF_CODE = PO2020.PF_CODE
        AND PO2020.SURVEY_YEAR = 2020
WHERE
    PO.SURVEY_YEAR = 2015
    AND PO2020.TOTAL_AMT > PO.TOTAL_AMT
ORDER BY
    "人口増加率" DESC,
    "都道府県コード" ASC;