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