WITH y2015 as (
select
    PF_CODE,
    TOTAL_AMT
from 
    POPU_TRANSITION
where
    SURVEY_YEAR = 2015
)
, y2020 as (
select
    PF_CODE,
    TOTAL_AMT
from 
    POPU_TRANSITION
where
    SURVEY_YEAR = 2020
)
select
    y2015.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    y2015.TOTAL_AMT as 総人口2015年,
    y2020.TOTAL_AMT as 総人口2020年,
    ROUND(
        CAST(y2020.TOTAL_AMT as REAL)
        / CAST(y2015.TOTAL_AMT as REAL) * 100, 0
    ) as 人口増加率
from
    y2015
    join y2020
    on y2020.TOTAL_AMT > y2015.TOTAL_AMT and y2020.PF_CODE = y2015.PF_CODE
    join PREFECTURE as PR
    on y2015.PF_CODE = PR.PF_CODE
order by 
    人口増加率 desc,
    y2015.PF_CODE