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