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