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