with p_15 as (
    select PF_CODE, TOTAL_AMT
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
),
p_20 as (
    select PF_CODE, TOTAL_AMT
    from POPU_TRANSITION
    where SURVEY_YEAR = 2020
)
select
    distinct pp.PF_CODE as '都道府県コード',
    pf.PF_NAME as '都道府県名',
    p_15.TOTAL_AMT as '総人口2015年',
    p_20.TOTAL_AMT as '総人口2020年',
    round(cast(p_20.TOTAL_AMT as real) * 100 / - cast(p_15.TOTAL_AMT as real)) as '人口増加率'
from
    POPU_TRANSITION pp
        inner join PREFECTURE pf
            on pp.PF_CODE = pf.PF_CODE
        inner join p_15
            on pp.PF_CODE = p_15.PF_CODE
        inner join p_20
            on pp.PF_CODE = p_20.PF_CODE
where
    p_15.TOTAL_AMT < p_20.TOTAL_AMT
order by
    人口増加率 desc,
    都道府県コード
;