select
  po15.PF_CODE as 都道府県コード,
  po15.PF_NAME as 都道府県名,
  po15.TOTAL_AMT as 総人口2015年,
  po20.TOTAL_AMT as 総人口2020年,
  round( ( (po20.TOTAL_AMT - po15.TOTAL_AMT) / cast(po15.TOTAL_AMT as real) + 1) * 100, 0 ) as 人口増加率

from (
  select 
    pf.PF_CODE,
    pf.PF_NAME,
    TOTAL_AMT
  from
    POPU_TRANSITION as po
  join PREFECTURE as pf on po.PF_CODE = pf.PF_CODE
  where po.SURVEY_YEAR = 2015
) as po15
join (
  select 
    pf.PF_CODE,
    pf.PF_NAME,
    TOTAL_AMT
  from
    POPU_TRANSITION as po
  join PREFECTURE as pf on po.PF_CODE = pf.PF_CODE
  where po.SURVEY_YEAR = 2020
) as po20 on po20.PF_CODE = po15.PF_CODE

where
  po20.TOTAL_AMT - po15.TOTAL_AMT > 0

order by
  人口増加率 desc,
  都道府県コード asc