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