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 AS S
   , PREFECTURE AS P 
WHERE
   S.SURVEY_YEAR = 2022 
   AND P.PF_CODE = S.PF_CODE 
ORDER BY
   RATIO DESC
   , S.PF_CODE ASC
;