select
    s.PF_CODE as CODE
    ,PF_NAME as NAME
    ,round(1.0*PROMOTE_MUNICIPALITY/MUNICIPALITY_TTL*100,2) as RATIO
from
    SDGS as s
    inner join
    PREFECTURE as pf
    on s.PF_CODE =pf.PF_CODE
where
    SURVEY_YEAR=2022
order by
    RATIO desc