select
    p15.pf_code "都道府県コード",
    pr.pf_name "都道府県名",
    p15.total_amt "総人口2015年",
    p20.total_amt "総人口2020年",
    round(100 * p20.total_amt / cast(p15.total_amt as real), 0) "人口増加率"
from
    (select pf_code, total_amt from popu_transition where survey_year = 2015) as p15
left outer join
    (select pf_code, total_amt from popu_transition where survey_year = 2020) as p20
on p15.pf_code = p20.pf_code
left outer join
    prefecture as pr
on p15.pf_code = pr.pf_code
where p15.total_amt < p20.total_amt
order by  p20.total_amt / cast(p15.total_amt as real) desc, "都道府県コード" asc