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)) "人口増加率"
from
    (select * from popu_transition where survey_year = 2015) as p15
left outer join
    (select * from popu_transition where survey_year = 2020) as p20
using(pf_code)
left outer join
    prefecture as pr
using(pf_code)
where p15.total_amt < p20.total_amt
order by 5 desc, 1 asc