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
inner join
    prefecture as p on y2015.pf_code = p.pf_code
where
    人口増加率 > 100
order by
    人口増加率 desc,
    都道府県コード asc
;