select
    s.PF_CODE as 'CODE'
    ,PF_NAME as 'NAME'
    ,round(cast(PROMOTE_MUNICIPALITY as REAL) / cast(MUNICIPALITY_TTL as REAL) * 100.0, 2) as 'RATIO'
from
    SDGS s
    ,PREFECTURE p on s.PF_CODE = p.PF_CODE
where
    SURVEY_YEAR = 2022
order by
    RATIO desc
    ,s.PF_CODE asc
;