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;