WITH POPU2015 AS
  (
    SELECT PF_CODE, TOTAL_AMT AS TOTAL2015 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015
  )
  , POPU2020 AS
  (
    SELECT PF_CODE, TOTAL_AMT AS TOTAL2020 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020
  )
  , POPU_RATE AS
  ( 
    SELECT 
      ROUND(CAST(TOTAL2020 AS REAL) * 100/ CAST(TOTAL2015 AS REAL)) AS ADD_RATE
      , TOTAL2015
      , TOTAL2020
      , PF_CODE
    FROM POPU2015
    JOIN POPU2020 USING(PF_CODE)
    WHERE ADD_RATE > 100
  )
SELECT POPU_RATE.PF_CODE AS 都道府県コード
  , PF_NAME AS 都道府県名
  , TOTAL2015 AS 総人口2015年
  , TOTAL2020 AS 総人口2020年
  , ADD_RATE AS 人口増加率
FROM
  POPU_RATE
  JOIN PREFECTURE USING(PF_CODE)
ORDER BY 5 DESC, 1 ASC;