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
inner join 
    PREFECTURE as P
on
    S.PF_CODE = P.PF_CODE
where 
    S.SURVEY_YEAR = 2022
order by 
    RATIO desc
    ,NAME asc