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