select
    y2015.pf_code as 都道府県コード,
    p.pf_name as 都道府県名,
    y2015.total_amt as 総人口2015年,
    y2020.total_amt as 総人口2020年,
    round(
        y2020.total_amt / cast(y2015.total_amt as float) * 100,
        0
    ) as 人口増加率
from
    (
        select
            pf_code,
            total_amt
        from
            popu_transition
        where
            survey_year = 2015
    ) as y2015 inner join (
        select
            pf_code,
            total_amt
        from
            popu_transition
        where
            survey_year = 2020
    ) as y2020 on (
        y2015.pf_code = y2020.pf_code and
        y2020.total_amt > y2015.total_amt
    )
inner join
    prefecture as p on y2015.pf_code = p.pf_code
order by
    人口増加率 desc,
    都道府県コード asc
;