select
  S.PF_CODE AS CODE
  , PF_NAME AS NAME
  , ROUND(CAST(PROMOTE_MUNICIPALITY as REAL)*100 / MUNICIPALITY_TTL, 2) 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
;