with pt_2020 as (
    select
        PF_CODE,
        TOTAL_AMT
    from
        POPU_TRANSITION
    where
        SURVEY_YEAR = 2020
),
pt_2015 as (
    select
        PF_CODE,
        TOTAL_AMT
    from
        POPU_TRANSITION
    where
        SURVEY_YEAR = 2015
)

select
    pf.PF_CODE as 都道府県コード,
    pf.PF_NAME as 都道府県名,
    pt_2015.TOTAL_AMT as 総人口2015年,
    pt_2020.TOTAL_AMT as 総人口2020年,
    round(
        cast(pt_2020.TOTAL_AMT as float) / pt_2015.TOTAL_AMT * 100,
        0
    ) as 人口増加率
from
    pt_2020
inner join
    pt_2015
    on pt_2020.PF_CODE = pt_2015.PF_CODE
        and pt_2020.TOTAL_AMT > pt_2015.TOTAL_AMT
inner join
    PREFECTURE as pf
    on pt_2020.PF_CODE = pf.PF_CODE
group by
    1,2
order by
    5 desc,1