select
    S.PF_CODE as CODE
    , P.PF_NAME as NAME
    , round(cast(S.PROMOTE_MUNICIPALITY as real)*100/S.MUNICIPALITY_TTL, 2) as RATIO
from
    SDGs as S
left join
    PREFECTURE as P on S.PF_CODE=P.PF_CODE
where
    S.SURVEY_YEAR=2022
order by
    RATIO desc
    , CODE asc
;