select PF.PF_CODE as CODE,
PF.PF_NAME as NAME,
round((100.00 * SDGS.PROMOTE_MUNICIPALITY/SDGS.MUNICIPALITY_TTL),3) as RATIO
from SDGS
LEFT JOIN PREFECTURE PF
on SDGS.PF_CODE = PF.PF_CODE
where SURVEY_YEAR = 2022
order by RATIO desc,CODE;