SELECT
    p.PF_CODE AS 都道府県コード,
    p.PF_NAME AS 都道府県名,
    MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS 総人口2015年,
    MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS 総人口2020年,
    ROUND(
        CAST(MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS REAL) /
        CAST(MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS REAL) * 100
    ) AS 人口増加率
FROM
    POPU_TRANSITION AS pt
    LEFT JOIN
        PREFECTURE AS p
    ON  p.PF_CODE = pt.PF_CODE
WHERE
    SURVEY_YEAR = 2015
    OR SURVEY_YEAR = 2020
GROUP BY
    p.PF_CODE, p.PF_NAME
HAVING
     MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) > MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END)
ORDER BY
    人口増加率 DESC,
    p.PF_CODE