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