select
    sd.PF_CODE as CODE
    ,pf.PF_NAME as NAME
    ,round((cast(sd.PROMOTE_MUNICIPALITY as double)/cast(sd.MUNICIPALITY_TTL as double))*100,2) as RATIO
from
    sdgs as sd
left join prefecture as pf
on sd.pf_code = pf.pf_code
where
    sd.SURVEY_YEAR = '2022'
order by
    ratio desc
    ,code asc