with t2015 as (
select pf_code, total_amt as p2015 from popu_transition where survey_year = 2015
)
, t2020 as (
select pf_code, total_amt as p2020 from popu_transition where survey_year = 2020
)
select pf_code as 都道府県コード, pf_name as 都道府県名, p2015 as 総人口2015, p2020 as 総人口2020, round(cast(p2020 as double)/p2015 * 100) as 人口増加率
from t2015 join t2020 using(pf_code) join prefecture using(pf_code)
where p2015 < p2020
order by 人口増加率 desc, 都道府県コード