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