select
    p.pf_code as "都道府県コード"
    , p.pf_name as "都道府県名"
    , p1.total_amt as "総人口2015年"
    , p2.total_amt as "総人口2020年"
    , round(cast(p2.total_amt as real)/p1.total_amt * 100) as "人口増加率"
from
    prefecture as p
    join popu_transition as p1 on p1.pf_code = p.pf_code and p1.survey_year = 2015
    join popu_transition as p2 on p2.pf_code = p.pf_code and p2.survey_year = 2020
where
    p1.total_amt < p2.total_amt
order by
    5 desc, 1