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