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