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

from
SDGS as sd
inner join PREFECTURE as pf
on sd.PF_CODE = pf.PF_CODE

where
sd.SURVEY_YEAR = 2022 

order by
RATIO desc, sd.PF_CODE;

-- 努力 未来 A BEAUTIFUL STAR！！！！！！！！！！！