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