SELECT
  pc2020 AS 都道府県コード,
  PREFECTURE.PF_NAME AS 都道府県名,
  amt2015 AS 総人口2015年,
  amt2020 AS 総人口2020年,
  ROUND(CAST(amt2020 as REAL) / CAST(amt2015 as REAL) * 100) as 人口増加率
FROM
  (SELECT PF_CODE as pc2015, TOTAL_AMT as amt2015 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015)
  INNER JOIN
  (SELECT PF_CODE as pc2020, TOTAL_AMT as amt2020 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020)
  ON pc2015 = pc2020 AND amt2020 > amt2015
  LEFT JOIN PREFECTURE
  ON pc2020 = PREFECTURE.PF_CODE
ORDER BY 人口増加率 DESC, 都道府県コード