select
    S.pf_code as CODE
    ,P.pf_name as NAME
    ,round(round(100000*promote_municipality/municipality_ttl)/10)/100 as RATIO
from
    SDGs S
    inner join 
        PREFECTURE P
        on 
            S.pf_code=P.pf_code
where
    survey_year=2022
order by 3 desc, 1
;