SELECT
	S.PF_CODE AS CODE
	,PF_NAME AS NAME
	,round(1.0 * PROMOTE_MUNICIPALITY / MUNICIPALITY_TTL * 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