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