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