with amt2015 as (select
pf_code,pf_name,total_amt
from
popu_transition natural join prefecture
where survey_year=2015
)
,amt2020 as (select
pf_code,pf_name,total_amt
from
popu_transition natural join prefecture
where survey_year=2020
)

select
amt2015.pf_code 都道府県コード
,amt2015.pf_name 都道府県名
,amt2015.total_amt 総人口2015年
,amt2020.total_amt 総人口2020年
,round(100*amt2020.total_amt/amt2015.total_amt) 人口増加率
from
amt2015 join amt2020 on amt2015.pf_code = amt2020.pf_code
order by 人口増加率 desc,都道府県コード;