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