select
  sdgs.pf_code as CODE,
  prefecture.pf_name as NAME,
  round((sdgs.promote_municipality * 100.0) / sdgs.municipality_ttl, 2) as RATIO
from
  sdgs
join
  prefecture
on
  sdgs.pf_code = prefecture.pf_code
where
  sdgs.survey_year = 2022
order by
  ratio desc,
  code asc;