SELECT
	t1.PF_CODE AS CODE
	,t1.PF_NAME AS NAME
	,ROUND((100 * t2.PROMOTE_MUNICIPALITY / t2.MUNICIPALITY_TTL),3) AS RATIO
FROM PREFECTURE AS t1
LEFT OUTER JOIN SDGS AS t2
	ON t1.PF_CODE = t2.PF_CODE
WHERE SURVEY_YEAR = 2022
ORDER BY RATIO DESC,t1.PF_CODE ASC