select
    pr.PF_CODE as 'CODE'
    ,pr.PF_NAME as 'NAME'
    ,round(cast(ss.PROMOTE_MUNICIPALITY as REAL) / cast(ss.MUNICIPALITY_TTL as REAL) * 100 ,3) as 'RATIO'
from 
    SDGS ss 
left join PREFECTURE pr
    on ss.PF_CODE = pr.PF_CODE
where 
    ss.SURVEY_YEAR = '2022'
order by
    round(cast(ss.PROMOTE_MUNICIPALITY as REAL) / cast(ss.MUNICIPALITY_TTL as REAL) * 100 ,3) desc
    ,ss.PF_CODE asc