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