select
  p_2015.PF_CODE as 都道府県コード, 
  p.PF_NAME as 都道府県名,
  p_2015.TOTAL_AMT as 総人口2015年,
  p_2020.TOTAL_AMT as 総人口2020年,
  round((cast(p_2020.TOTAL_AMT as real) / cast(p_2015.TOTAL_AMT as real)) * 100) as 人口増加率
from
  (
    select
      PF_CODE,
      TOTAL_AMT
    from
      POPU_TRANSITION pt
    where
      pt.SURVEY_YEAR = 2015
  ) as p_2015
left outer join
  (
    select
      PF_CODE,
      TOTAL_AMT
    from
      POPU_TRANSITION pt
    where
      pt.SURVEY_YEAR = 2020
  ) as p_2020 on p_2020.PF_CODE = p_2015.PF_CODE
left outer join
  PREFECTURE p on p_2015.PF_CODE = p.PF_CODE
where
  p_2020.TOTAL_AMT > p_2015.TOTAL_AMT
order by 人口増加率 desc, 都道府県コード asc;