select
    s.PF_CODE as CODE
    , pf.PF_NAME as NAME
    , ROUND( 
        ( 
            CAST(s.PROMOTE_MUNICIPALITY as real) / CAST(s.MUNICIPALITY_TTL as real)
        ) * 100
        , 2
    ) as RATIO 
from
    SDGS s 
    inner join PREFECTURE as pf 
        on s.PF_CODE = pf.PF_CODE 
where
    s.SURVEY_YEAR = "2022" 
order by
    RATIO desc
    , s.PF_CODE asc