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