SELECT
    PRE.PF_CODE "都道府県コード",
    PRE.PF_NAME "都道府県名",
    P2015 "総人口2015年",
    P2020 "総人口2020年",
    ROUND(CAST(P2020*100 AS FLOAT) / P2015) "人口増加率"
FROM
    (SELECT
        PF_CODE,
        SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS P2015,
        SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS P2020
    FROM
        POPU_TRANSITION
    GROUP BY
        PF_CODE) AS POP
JOIN
    PREFECTURE AS PRE
    ON POP.PF_CODE = PRE.PF_CODE
WHERE
    "人口増加率" >= 100
ORDER BY
    "人口増加率" DESC,
    PRE.PF_CODE ASC