select
    s.PF_CODE as CODE
    , PF_NAME as NAME
    , round(100.0 * PROMOTE_MUNICIPALITY / MUNICIPALITY_TTL, 2) as RATIO
from 
    SDGS s
    left outer join
        PREFECTURE p
        on s.PF_CODE = p.PF_CODE
where
    SURVEY_YEAR = 2022
order by
    RATIO desc
    , s.PF_CODE