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