select 
    prf.pf_code as "都道府県コード",
    prf.pf_name as "都道府県名",
    pt1.total_amt as "総人口2015年",
    pt2.total_amt as "総人口2020年",
    round((cast(pt2.total_amt as real) * 100 / pt1.total_amt),0) as "人口増加率"
from 
    prefecture prf 
    join popu_transition pt1
        on prf.pf_code = pt1.pf_code
        and pt1.survey_year = 2015
    join popu_transition pt2
        on prf.pf_code = pt2.pf_code
        and pt2.survey_year = 2020
where 
    pt2.total_amt > pt1.total_amt
order by 
    "人口増加率" desc, "都道府県コード" asc;