select
  PREFECTURE.PF_CODE as 都道府県コード,
  PREFECTURE.PF_NAME as 都道府県名,
  PT_2015.TOTAL_AMT as '総人口2015年',
  PT_2020.TOTAL_AMT as '総人口2020年',
  round(cast(PT_2020.TOTAL_AMT as REAL)/cast(PT_2015.TOTAL_AMT as REAL) *100) as 人口増加率
from
  (
    select
      PF_CODE,
      TOTAL_AMT
    from
      POPU_TRANSITION
    where
      SURVEY_YEAR = 2015
  ) as PT_2015
join 
  (
    select
      PF_CODE,
      TOTAL_AMT
    from
      POPU_TRANSITION
    where
      SURVEY_YEAR = 2020
  ) as PT_2020
on PT_2015.PF_CODE = PT_2020.PF_CODE
join
  PREFECTURE
  on PT_2015.PF_CODE = PREFECTURE.PF_CODE
where
  PT_2015.TOTAL_AMT < PT_2020.TOTAL_AMT
order by
  人口増加率 desc,
  都道府県コード asc