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