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(cast(pop_2020.total_amt as real) * 100 / cast(pop_2015.total_amt as real)) 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

where
  pop_2015.total_amt <= pop_2020.total_amt

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