select
    pf.pf_code as "都道府県コード",
    pf.pf_name as "都道府県名",
    pt15.total_amt as "総人口2015年",
    pt20.total_amt as "総人口2020年",
    round(pt20.total_amt * 100.0 / pt15.total_amt) as "人口増加率"
from
    popu_transition pt15
    left outer join popu_transition pt20
    on
        pt15.survey_year = 2015
        and pt20.survey_year = 2020
        and pt15.pf_code = pt20.pf_code
    left outer join prefecture pf
    on pt15.pf_code = pf.pf_code
where
    pt15.total_amt < pt20.total_amt
order by
    "人口増加率" desc, "都道府県コード" asc