SELECT
	t1.PF_CODE AS CODE
	,t1.PF_NAME AS NAME
	,ROUND((100 * ROUND(t2.PROMOTE_MUNICIPALITY) / ROUND(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