select
P.PF_CODE as CODE,
P.PF_NAME as NAME,
round(S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL * 100 , 3) as RATIO
from SDGS S, PREFECTURE P
where
S.PF_CODE = P.PF_CODE
and S.SURVEY_YEAR = 2022
order by RATIO desc,CODE asc