SELECT PR.PF_CODE AS 都道府県コード
,PR.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 PT
LEFT JOIN PREFECTURE PR
ON PT.PF_CODE =PR.PF_CODE 
INNER JOIN POPU_TRANSITION PT2020
ON PT2020.PF_CODE =PT.PF_CODE 
AND PT2020.SURVEY_YEAR=2020
WHERE 1=1
AND PT.SURVEY_YEAR=2015
AND PT2020.TOTAL_AMT> PT.TOTAL_AMT


ORDER BY 人口増加率 desc,
都道府県コード asc