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