select PF.PF_CODE as CODE,
PF.PF_NAME as NAME,
(100 * SDGS.PROMOTE_MUNICIPALITY/SDGS.MUNICIPALITY_TTL) as RATIO
from SDGS
LEFT JOIN PREFECTURE PF
on SDGS.PF_CODE = PF.PF_CODE
order by RATIO,CODE;