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