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