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