select
	p.PF_CODE AS "CODE",
	p.PF_NAME AS "NAME",
	round( (s.PROMOTE_MUNICIPALITY * 100.0 / s.MUNICIPALITY_TTL) * 100) / 100 AS "RATIO"
from
	SDGS s
inner join PREFECTURE p
		using (pf_code)
where
	SURVEY_YEAR = 2022
order by
	"RATIO" desc,
	PF_CODE asc;