with pop_2020 as (
  select
    pf_code,
    total_amt

  from
    popu_transition

  where
    survey_year = 2020
),
pop_2015 as (
  select
    pf_code,
    total_amt

  from
    popu_transition

  where
    survey_year = 2015
)

select
  pop_2015.pf_code as "都道府県コード",
  prefecture.pf_name as "都道府県名",
  pop_2015.total_amt as "総人口2015年",
  pop_2020.total_amt as "総人口2020年",
  round(pop_2020.total_amt * 100 / pop_2015.total_amt) as "人口増加率"

from pop_2015
  inner join pop_2020
    on pop_2020.pf_code = pop_2015.pf_code

  inner join prefecture
    on prefecture.pf_code = pop_2015.pf_code

order by
  round(pop_2020.total_amt * 100 / pop_2015.total_amt) desc,
  prefecture.pf_code asc