WITH
  POPU15 AS (
    SELECT
      PF_CODE
      , TOTAL_AMT
    FROM
      POPU_TRANSITION
    WHERE
      SURVEY_YEAR = 2015
  )
  
  , POPU20 AS (
    SELECT
      PF_CODE
      , TOTAL_AMT
    FROM
      POPU_TRANSITION
    WHERE
      SURVEY_YEAR = 2020
  )
SELECT
  PREFECTURE.PF_CODE AS 都道府県コード
  , PREFECTURE.PF_NAME AS 都道府県名
  , POPU15.TOTAL_AMT AS 総人口2015年
  , POPU20.TOTAL_AMT AS 総人口2020年
  , ROUND(POPU20.TOTAL_AMT * 100.0 / POPU15.TOTAL_AMT, 0) AS 人口増加率
FROM
  PREFECTURE
INNER JOIN
  POPU15
ON
  PREFECTURE.PF_CODE = POPU15.PF_CODE
INNER JOIN
  POPU20
ON
  PREFECTURE.PF_CODE = POPU20.PF_CODE
WHERE
  POPU20.TOTAL_AMT > POPU15.TOTAL_AMT
ORDER BY
  人口増加率 DESC
  , 都道府県コード
;