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年
    , ROUND(
        100
        * CAST(SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS REAL)
        / CAST(SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS REAL)
    , 0) AS 人口増加率

FROM
    POPU_TRANSITION
LEFT JOIN PREFECTURE
USING(PF_CODE)

GROUP BY
    PF_CODE
    , PF_NAME

ORDER BY
    人口増加率 DESC
    , PF_CODE ASC