select
    wk1.PF_CODE as '都道府県コード',
    wk3.PF_NAME as '都道府県名',
    wk1.total_2015 as '総人口2015年',
    wk2.total_2020 as '総人口2020年',
    round(cast(wk2.total_2020 as real)*100/cast(wk1.total_2015 as real),0) as '人口増加率'
from
    (select
        PF_CODE,
        TOTAL_AMT as total_2015
    from
        POPU_TRANSITION
    where
        SURVEY_YEAR = 2015
    ) as wk1
inner join
    (select
        PF_CODE,
        TOTAL_AMT as total_2020
    from
        POPU_TRANSITION
    where
        SURVEY_YEAR = 2020
    ) as wk2
on
    wk1.PF_CODE = wk2.PF_CODE
inner join
    PREFECTURE as wk3
on
    wk1.PF_CODE = wk3.PF_CODE
where
    人口増加率 > 100
order by
    人口増加率 desc,
    都道府県コード asc
;