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