with
    t2015 as (
        select
            *
        from
            popu_transition
        where
            survey_year = 2015
    )
    ,t2020 as (
        select
            *
        from
            popu_transition
        where
            survey_year = 2020
    )

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