select
sd.PF_CODE as CODE,
pf.PF_NAME as NAME,
round(
(cast(sd.PROMOTE_MUNICIPALITY as float) / sd.MUNICIPALITY_TTL * 100),2) as RATIO

from SDGS as sd
join PREFECTURE as pf
using(PF_CODE)

where sd.SURVEY_YEAR = 2022
order by 3 desc ,1
;