WITH t1 AS(
    SELECT
        PF_CODE AS "都道府県コード",
        PF_NAME AS "都道府県名",
        SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS "総人口2015年",
        SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS "総人口2020年"
    FROM POPU_TRANSITION
    LEFT JOIN PREFECTURE USING(PF_CODE)
    GROUP BY 1, 2
)

SELECT
    *,
    ROUND(100.0 * "総人口2020年" / "総人口2015年") AS "人口増加率"
FROM t1
WHERE "総人口2020年" > "総人口2015年"
ORDER BY 5 DESC, 1