SELECT PT.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 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 人口増加率>100
ORDER BY 人口増加率 DESC,都道府県コード ASC