with p2015 as (
    select pf_code, total_amt
    from popu_transition
    where
    survey_year = 2015
), p2020 as (
    select pf_code, total_amt
    from popu_transition
    where
    survey_year = 2020
)
select
    distinct p2015.pf_code as 都道府県コード,
    prefecture.pf_name,
    p2015.total_amt as 総人口2015年,
    p2020.total_amt as 総人口2020年,
    cast( round( cast(p2020.total_amt as real) / cast(p2015.total_amt as real) * 100 ) as integer ) as 人口増加率
from
    p2015, p2020, prefecture
where
    p2015.pf_code = p2020.pf_code
    and
    p2015.pf_code = prefecture.pf_code
    and
    p2015.total_amt < p2020.total_amt
    order by 人口増加率 desc, p2015.pf_code asc
;