select
  prf.PF_CODE as 都道府県コード,
  prf.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 prf
inner join
  POPU_TRANSITION pt2015
on
  pt2015.PF_CODE = prf.PF_CODE and pt2015.SURVEY_YEAR = 2015
inner join
  POPU_TRANSITION pt2020
on
  pt2020.PF_CODE = prf.PF_CODE and pt2020.SURVEY_YEAR = 2020
where 
  人口増加率 >= 100
order by 人口増加率 desc, 都道府県コード asc