select 
    p.pf_code as "都道府県コード", 
    pf_name as "都道府県名", 
    y2015.total_amt as "総人口2015年", 
    y2020.total_amt as "総人口2020年", 
    (round(y2020.total_amt * 1.0 / y2015.total_amt, 2) * 100) 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;