select 
  p.PF_CODE as "都道府県コード",
  p.PF_NAME as "都道府県名",
  t2015.TOTAL_AMT as "総人口2015年",
  t2020.TOTAL_AMT as "総人口2020年",
  ROUND(cast(t2020.TOTAL_AMT as REAL) / cast(t2015.TOTAL_AMT as REAL), 2) * 100 as "人口増加率"
from PREFECTURE as p
join POPU_TRANSITION as t2015 on p.PF_CODE = t2015.PF_CODE and t2015.SURVEY_YEAR = 2015
join POPU_TRANSITION as t2020 on p.PF_CODE = t2020.PF_CODE and t2020.SURVEY_YEAR = 2020
where "人口増加率" >= 100
order by "人口増加率" desc, p.PF_CODE asc