select 
  p.PF_CODE CODE,
  p.PF_NAME NAME,
  format('%.2f', 100.0 * s.PROMOTE_MUNICIPALITY/s.MUNICIPALITY_TTL) RATIO
from sdgs s
left join prefecture p using(pf_code)
where s.SURVEY_YEAR = 2022
order by 3 desc, 1