SELECT
S.PF_CODE AS CODE,
P.PF_NAME AS NAME,
ROUND((CAST(S.PROMOTE_MUNICIPALITY AS REAL) / S.MUNICIPALITY_TTL) * 100, 2) AS RATIO

FROM SDGS AS S
 INNER JOIN PREFECTURE AS P
 ON S.PF_CODE = P.PF_CODE
 
WHERE
 S.SURVEY_YEAR = '2022'
 
GROUP BY
CODE, NAME

ORDER BY
RATIO DESC,
S.PF_CODE ASC;