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