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