SELECT
  YOKO.PF_CODE AS 都道府県コード,
  PF_NAME AS 都道府県名,
  NUM_2015 AS 総人口2015年,
  NUM_2020 AS 総人口2020年,
  ROUND(CAST(NUM_2020 AS REAL) / CAST(NUM_2015 AS REAL) * 100, 0) AS 人口増加率
FROM
  (
    SELECT
      PF_CODE,
      SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS NUM_2015,
      SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS NUM_2020
    FROM
      POPU_TRANSITION
    GROUP BY
      PF_CODE
  ) AS YOKO
  LEFT JOIN PREFECTURE AS PRE ON YOKO.PF_CODE = PRE.PF_CODE
WHERE
  NUM_2015 < NUM_2020
ORDER BY
  人口増加率 desc,
  都道府県コード