SELECT
    PT.PF_CODE AS "都道府県コード",
    PR.PF_NAME AS "都道府県名",
    (SELECT
        SUM(TOTAL_AMT)
        FROM POPU_TRANSITION
        WHERE TOTAL_AMT = 2015
        ) AS "総人口2015年",
    (SELECT
        SUM(TOTAL_AMT)
        FROM POPU_TRANSITION
        WHERE TOTAL_AMT = 2020
        ) AS "総人口2020年",
    ROUND("総人口2015年" / "総人口2020年" * 100) AS "人口増加率"
FROM
    POPU_TRANSITION AS PT
INNER JOIN PREFECTURE AS PR ON PT.PF_CODE = PR.PF_CODE
ORDER BY
    "人口増加率" DESC
    PT.PF_CODE ASC;