with
    pop_2015 as (
    select pf_code, total_amt from popu_transition
    where survey_year == 2015
    ),
    pop_2020 as (
    select pf_code, total_amt from popu_transition
    where survey_year == 2020
    )
select
    pref.PF_CODE as 都道府県コード,
    pref.PF_NAME as 都道府県名,
    pop_2015.total_amt as 総人口2015年,
    pop_2020.total_amt as 総人口2020年,
    round(pop_2020.total_amt * 100.0 / pop_2015.total_amt) as 人口増加率
from
    prefecture as pref
    inner join pop_2015
        on pref.pf_code == pop_2015.pf_code
    inner join pop_2020
        on pref.pf_code == pop_2020.pf_code
where
    総人口2015年 <= 総人口2020年
order by
    人口増加率 desc,
    都道府県コード asc
;