SELECT WK.PF_CODE AS CODE,
       P.PF_NAME AS NAME,
       WK.RATIO AS RATIO
  FROM (SELECT PF_CODE,
               ROUND(CAST(PROMOTE_MUNICIPALITY  AS REAL)/ CAST(MUNICIPALITY_TTL AS REAL) * 100,2) AS RATIO
          FROM SDGS
         WHERE SURVEY_YEAR = 2022
       ) WK LEFT JOIN PREFECTURE P
              ON WK.PF_CODE = P.PF_CODE
ORDER BY RATIO DESC,CODE ASC