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