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