select
 p.PF_CODE  都道府県コード
,p.PF_NAME  都道府県名
,t15.TOTAL_AMT  総人口2015年
,t20.TOTAL_AMT  総人口2020年
,round(cast(t20.TOTAL_AMT *100 as real) / cast(t15.TOTAL_AMT as real)) 人口増加率
from 
  POPU_TRANSITION t15
  inner join
  POPU_TRANSITION t20
  on t15.PF_CODE = t20.PF_CODE
  and t15.TOTAL_AMT < t20.TOTAL_AMT
  inner join
  PREFECTURE p
  on t15.PF_CODE = p.PF_CODE
where
  t15.SURVEY_YEAR = 2015
  and t20.SURVEY_YEAR = 2020
order by 
5 desc
,1  
  ;