select T2015.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)) * 100) as 人口増加率
  from POPU_TRANSITION T2015
 inner join PREFECTURE P
    on T2015.PF_CODE = P.PF_CODE
  left join POPU_TRANSITION T2020
    on T2015.PF_CODE = T2020.PF_CODE
   and T2020.SURVEY_YEAR = 2020
 where T2015.TOTAL_AMT <= T2020.TOTAL_AMT
 order by 人口増加率 desc, 都道府県コード