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