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