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