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