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