select 
    S.PF_CODE as CODE
    ,P.PF_NAME as NAME
    , ROUND( 
        ( 
            -- REAL型に変換して、小数点の計算を有効にする
            CAST(S.PROMOTE_MUNICIPALITY AS REAL) / S.MUNICIPALITY_TTL * 100
        ) 
        , 2
    ) AS RATIO 
from
    SDGS as S
inner join 
    PREFECTURE as P
on
    S.PF_CODE = P.PF_CODE
where 
    S.SURVEY_YEAR = 2022
order by 
    RATIO desc
    ,NAME asc