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