SELECT 
    PO.PF_CODE AS 都道府県コード
    , PR.PF_NAME AS 都道府県名
    , SUM(PO.TOTAL_AMT) AS 総人口2015年
    , SUM(PO2020.TOTAL_AMT) AS 総人口2020年
    , ROUND(CAST(SUM(PO2020.TOTAL_AMT) AS REAL) / SUM(PO.TOTAL_AMT) * 100) AS 人口増加率

FROM
    POPU_TRANSITION AS PO -- 2015年のデータ
    INNER JOIN 
        PREFECTURE AS PR
        ON PO.PF_CODE = PR.PF_CODE
    INNER JOIN
        POPU_TRANSITION AS PO2020 -- 2020年のデータ
        ON PO.PF_CODE = PO2020.PF_CODE
        AND PO2020.SURVEY_YEAR = 2020
        AND PO2020.TOTAL_AMT > PO.TOTAL_AMT
WHERE
    PO.SURVEY_YEAR = 2015
GROUP BY
    PO.PF_CODE
ORDER BY
    人口増加率 DESC
    , 都道府県コード ASC