with
a as (
select
    PF_CODE,
    TOTAL_AMT
from
    POPU_TRANSITION
where
    SURVEY_YEAR = 2015
),
b as (
select
    PF_CODE,
    TOTAL_AMT
from
    POPU_TRANSITION
where
    SURVEY_YEAR = 2020
)
select
    a.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as 都道府県名,
    a.TOTAL_AMT as 総人口2015年,
    b.TOTAL_AMT as 総人口2020年,
    round(cast((b.TOTAL_AMT) * 100 as float) / a.TOTAL_AMT)  as 人口増加率
from
    a
inner join
    b
on
    a.PF_CODE = b.PF_CODE
inner join
    PREFECTURE
on
    a.PF_CODE = PREFECTURE.PF_CODE
where
    b.TOTAL_AMT > a.TOTAL_AMT
order by
    人口増加率 desc,
    都道府県コード