WITH SUBSUM AS (
    SELECT
        PF_CODE
      , SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS SUM2015
      , SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS SUM2020
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR IN (2015, 2020)
    GROUP BY
        PF_CODE
)
SELECT
    T1.PF_CODE AS "都道府県コード"
  , M1.PF_NAME AS "都道府県名"
  , T1.SUM2015 AS "総人口2015年"
  , T1.SUM2020 AS "総人口2020年"
  , ROUND(CAST(T1.SUM2020 AS REAL) / T1.SUM2015 * 100) AS "人口増加率"
FROM
    SUBSUM T1
    LEFT OUTER JOIN PREFECTURE M1
        ON T1.PF_CODE = M1.PF_CODE
WHERE
    T1.SUM2020 > T1.SUM2015
ORDER BY
    人口増加率     DESC
  , 都道府県コード
;