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