SELECT
 A.PF_CODE AS 都道府県コード,
 A.PF_NAME AS 都道府県名,
 B_2015.TOTAL_AMT AS 総人口2015年,
 B_2020.TOTAL_AMT AS 総人口2020年,
 ROUND(CAST(100 AS REAL) * B_2020.TOTAL_AMT / B_2015.TOTAL_AMT) AS 人口増加率
FROM
 PREFECTURE A
JOIN
 (SELECT 
  *
  FROM
   POPU_TRANSITION
  WHERE
   SURVEY_YEAR = 2015) AS B_2015
ON
 A.PF_CODE = B_2015.PF_CODE
JOIN
 (SELECT 
 *
 FROM
  POPU_TRANSITION
 WHERE
  SURVEY_YEAR = 2020) AS B_2020
ON
 A.PF_CODE = B_2020.PF_CODE
WHERE
 B_2015.TOTAL_AMT < B_2020.TOTAL_AMT
ORDER BY
 人口増加率 DESC,
 A.PF_CODE
;