SELECT
  PT.PF_CODE AS 都道府県コード,
  PF.PF_NAME AS 都道府県名,
  PT.TOTAL_AMT AS 総人口2015年,
  PT2.TOTAL_AMT AS 総人口2020年,
  ROUND(PT2.TOTAL_AMT / PT.TOTAL_AMT * 100) AS 人口増加率
FROM
  POPU_TRANSITION AS PT
  JOIN PREFECTURE AS PF 
  ON PF.PF_code = PT.PF_code
  JOIN POPU_TRANSITION AS PT2 
  ON PT2.PF_CODE = PT.PF_CODE
  AND PT2.SURVEY_YEAR = 2020
WHERE
  PT.SURVEY_YEAR = 2015
  AND PT2.TOTAL_AMT >= PT.TOTAL_AMT
ORDER BY
  人口増加率 DESC,
  都道府県コード ASC;