SELECT 
	PRE.PF_CODE AS CODE
	,PRE.PF_NAME AS NAME
	,ROUND((SDG.PROMOTE_MUNICIPALITY/SDG.MUNICIPALITY_TTL)*100,2) AS RAITO
FROM
	PREFECTURE PRE
INNER JOIN
	SDGS SDG
	ON PRE.PF_CODE = SDG.PF_CODE
WHERE
	SDG.SURVEY_YEAR = 2022
ORDER BY
	SDG.PROMOTE_MUNICIPALITY/SDG.MUNICIPALITY_TTL*100 DESC
	,PRE.PF_CODE;