SELECT PT.PF_CODE AS 都道府県コード
,PF_NAME AS 都道府県名
,PT2015.TOTAL_AMT AS 総人口2015年
,PT.TOTAL_AMT AS 総人口2020年
,ROUND(CAST(PT.TOTAL_AMT AS REAL)/CAST(PT2015.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 PT2015
ON PT2015.PF_CODE = PT.PF_CODE
AND PT2015.SURVEY_YEAR=2015
WHERE PT.SURVEY_YEAR=2020
AND PT.TOTAL_AMT>PT2015.TOTAL_AMT
GROUP BY PT.PF_CODE
,PF_NAME
ORDER BY 人口増加率 desc
,都道府県コード asc