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