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