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