select
    pf.pf_code as code,
    pf.pf_name as name,
    sdgs.PROMOTE_MUNICIPALITY / sdgs.MUNICIPALITY_TTL * 100 as raito
from
    SDGS as sdgs
inner join
    PREFECTURE as pf on sdgs.pf_code = sdgs.pf_code
order by
    raito desc,
    pf.pf_code asc
;