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