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
    where y2015.total_amt < y2020.total_amt
    order by "人口増加率" desc, p.pf_code asc;