select
  S.PF_CODE AS CODE
  , PF_NAME AS NAME
  , ROUND(PROMOTE_MUNICIPALITY*10000 / MUNICIPALITY_TTL)/100 AS RATIO
from
  SDGS AS S
inner join
  PREFECTURE AS P
on
  S.PF_CODE = P.PF_CODE
where
  SURVEY_YEAR = 2022
order by
  RATIO desc
  , S.PF_CODE
;