WITH transition AS (
  SELECT DISTINCT
    A.PF_CODE,
    (SELECT TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015 AND PF_CODE = A.PF_CODE) AS "総人口2015年",
    (SELECT TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020 AND PF_CODE = A.PF_CODE) AS "総人口2020年"
  FROM
    POPU_TRANSITION AS A
)
SELECT
  A.PF_CODE AS 都道府県コード,
  B.PF_NAME AS 都道府県名,
  A."総人口2015年",
  A."総人口2020年",
  ROUND(100 * (1.0 * A."総人口2020年") / (1.0 * A."総人口2015年")) AS 人口増加率
FROM
  transition as A
INNER JOIN
  PREFECTURE AS B
ON
  A.PF_CODE = B.PF_CODE
WHERE
  A."総人口2020年" > A."総人口2015年"
ORDER BY
  人口増加率 DESC,
  A.PF_CODE
;