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