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