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