select
  p0.PF_CODE 都道府県コード
 ,p1.PF_NAME 都道府県名
 ,p0.TOTAL_AMT 総人口2015年
 ,p2.TOTAL_AMT 総人口2020年
 ,round(cast(p2.TOTAL_AMT as real)/cast(p0.TOTAL_AMT as real)*100,0) 人口増加率
from POPU_TRANSITION p0
  inner join PREFECTURE p1
    on p1.PF_CODE=p0.PF_CODE
  inner join POPU_TRANSITION p2
    on p2.PF_CODE=p0.PF_CODE
    and p2.SURVEY_YEAR=2020
where p0.SURVEY_YEAR=2015
and p2.TOTAL_AMT>=p0.TOTAL_AMT
order by 人口増加率 desc
         ,p0.PF_CODE