select
  p.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 as s
       join PREFECTURE as p
           on s.PF_CODE = p.PF_CODE
 where s.SURVEY_YEAR = 2022
 order by
   RATIO desc,
   s.PF_CODE asc
   ;