SELECT
   S.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 S 
   INNER JOIN PREFECTURE P 
      ON S.PF_CODE = P.PF_CODE 
WHERE
   SURVEY_YEAR = 2022 
ORDER BY
   RATIO DESC
   , CODE ASC