select  p.PF_CODE as CODE
        ,p.PF_NAME as NAME
        ,round(s.PROMOTE_MUNICIPALITY * 100 / s.MUNICIPALITY_TTL,3) as RATIO
  from  SDGS s,PREFECTURE p
 where  p.PF_CODE = s.PF_CODE
   and  SURVEY_YEAR = 2022
 order by round(s.PROMOTE_MUNICIPALITY * 100 / s.MUNICIPALITY_TTL,3) desc,p.PF_CODE