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