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