SELECT PT.PF_CODE AS 都道府県コード
,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,0) AS 人口増加率
FROM POPU_TRANSITION AS PT
LEFT JOIN PREFECTURE AS PR
ON PT.PF_CODE =PR.PF_CODE 
INNER JOIN POPU_TRANSITION AS PT2020
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;