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