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