WITH popu_2015 AS
(
 SELECT
  PF_CODE,
  TOTAL_AMT
 FROM
  POPU_TRANSITION
 WHERE
  SURVEY_YEAR = 2015
),
popu_2020 AS
(
 SELECT
  PF_CODE,
  TOTAL_AMT
 FROM
  POPU_TRANSITION
 WHERE
  SURVEY_YEAR = 2020
)



SELECT
 a.PF_CODE AS '都道府県コード',
 c.PF_NAME AS '都道府県名',
 a.TOTAL_AMT AS '総人口2015年',
 b.TOTAL_AMT AS '総人口2020年',
 ROUND(CAST(b.TOTAL_AMT AS REAL) * 100 / a.TOTAL_AMT) AS '人口増加率'
FROM
 popu_2015 AS a
LEFT JOIN
 popu_2020 AS b
USING
 (PF_CODE)
LEFT JOIN
 PREFECTURE AS c
USING
 (PF_CODE)
WHERE
  ROUND(CAST(b.TOTAL_AMT AS REAL) * 100 / a.TOTAL_AMT) >= 100
ORDER BY
 5 DESC,1