SELECT PF_CODE as "都道府県コード", PF_NAME as "都道府県名", "総人口2015年", "総人口2020年", "人口増加率"
FROM (
 SELECT p1.PF_CODE, PF_NAME, p1.TOTAL_AMT as "総人口2015年", p2.TOTAL_AMT as "総人口2020年", round(p2.TOTAL_AMT * 100.0 / p1.TOTAL_AMT, 0) as "人口増加率"
 FROM POPU_TRANSITION as p1
 INNER JOIN POPU_TRANSITION as p2
 ON p1.PF_CODE = p2.PF_CODE
 INNER JOIN  PREFECTURE as p
 ON p1.PF_CODE = p.PF_CODE
 WHERE p1.SURVEY_YEAR = 2015 AND p2.SURVEY_YEAR = 2020
)
WHERE "人口増加率" >= 100
ORDER BY "人口増加率" desc, "都道府県コード"