SELECT
  SDGS.PF_CODE AS CODE,
  PF_NAME AS NAME,
  ROUND(PROMOTE_MUNICIPALITY / cast(MUNICIPALITY_TTL as real), 4) * 100 AS RATIO
FROM
  SDGS
  INNER JOIN PREFECTURE ON SDGS.PF_CODE = PREFECTURE.PF_CODE
WHERE
  SURVEY_YEAR = 2022
ORDER BY
  ROUND(PROMOTE_MUNICIPALITY / cast(MUNICIPALITY_TTL as real), 4) * 100 DESC,
  SDGS.PF_CODE ASC