SELECT PT1.PF_CODE AS 都道府県コード,
PR.PF_NAME AS 都道府県名,
PT1.TOTAL_AMT AS 総人口2015年,
PT2.TOTAL_AMT AS 総人口2020年,
ROUND(CAST (PT2.TOTAL_AMT AS REAL)/CAST (PT1.TOTAL_AMT AS REAL)*100)
   AS 人口増加率
   
FROM
  POPU_TRANSITION AS PT1
  INNER JOIN PREFECTURE AS PR
   ON PR.PF_CODE = PT1.PF_CODE

  INNER JOIN POPU_TRANSITION AS PT2
   ON PT1.PF_CODE = PT2.PF_CODE
   AND PT2.SURVEY_YEAR=2020
 

 
 
 WHERE PT1.SURVEY_YEAR =  2015 
       AND PT2.TOTAL_AMT >= PT1.TOTAL_AMT

ORDER BY 人口増加率 DESC,都道府県コード ASC;