SELECT
  PREFECTURE.PF_CODE AS "都道府県コード",
  PF_NAME AS "都道府県名",
  TOTAL_AMT_2015 AS "総人口2015年",
  TOTAL_AMT_2020 AS "総人口2020年",
  ROUND(TOTAL_AMT_2020 / TOTAL_AMT_2015 * 100) AS "人口増加率"
FROM
  PREFECTURE
LEFT JOIN
  (SELECT PF_CODE, CAST(TOTAL_AMT AS REAL) AS TOTAL_AMT_2015 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015) AS POPU_TRANSITION_2015
ON
  PREFECTURE.PF_CODE = POPU_TRANSITION_2015. PF_CODE
LEFT JOIN
  (SELECT PF_CODE, CAST(TOTAL_AMT AS REAL) AS TOTAL_AMT_2020 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020) AS POPU_TRANSITION_2020
ON
  PREFECTURE.PF_CODE = POPU_TRANSITION_2020. PF_CODE
WHERE
  "人口増加率" > 100
ORDER BY
  "人口増加率" DESC,
  "都道府県コード"