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