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