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