SELECT
    S.PF_CODE AS CODE
    , P.PF_NAME AS NAME
    , ROUND((CAST(S.PROMOTE_MUNICIPALITY AS REAL) / S.MUNICIPALITY_TTL) * 100, 2) AS RATIO
FROM
    PREFECTURE AS P
    INNER JOIN SDGS AS S
    ON P.PF_CODE = S.PF_CODE

WHERE
    S.SURVEY_YEAR = 2022

ORDER BY
    RATIO DESC
    , CODE ASC
;