with
t_2015 as (
select pf_code, total_amt
from popu_transition
where survey_year = 2015
),
t_2020 as (
select pf_code, total_amt
from popu_transition
where survey_year = 2020
)
select
    t_2015.pf_code as 都道府県コード,
    p.pf_name as 都道府県名,
    t_2015.total_amt as 総人口2015年,
    t_2020.total_amt as 総人口2020年,
    round(100.0 * t_2020.total_amt / t_2015.total_amt, 0) as 人口増加率
from t_2015
inner join
    prefecture p on p.pf_code = t_2015.pf_code,
    t_2020 on t_2020.pf_code = t_2015.pf_code
where 人口増加率 > 100
order by 人口増加率 desc, 都道府県コード asc