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