select 
 pre.PF_CODE as 都道府県コード
 ,PF_NAME as 都道府県名
 ,po2015.TOTAL_AMT as 総人口2015年
 ,po2020.TOTAL_AMT as 総人口2020年
 ,ROUND(cast(po2020.TOTAL_AMT as real) / cast(po2015.TOTAL_AMT as real) * 100 ,0) as 人口増加率
from prefecture pre
 inner join POPU_TRANSITION po2015
   on pre.PF_CODE = po2015.PF_CODE
    and po2015.SURVEY_YEAR = 2015
 inner join POPU_TRANSITION po2020
   on pre.PF_CODE = po2020.PF_CODE
    and po2020.SURVEY_YEAR = 2020
order by
  人口増加率 desc, 都道府県コード asc;