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 
    LEFT OUTER JOIN PREFECTURE ON CODE = PREFECTURE.PF_CODE
    WHERE SURVEY_YEAR = 2022
    ORDER BY RATIO DESC, SDGS.PF_CODE DESC