select 
S.PF_CODE as CODE,
P.PF_NAME as NAME,
ROUND(CAST(PROMOTE_MUNICIPALITY as real) / MUNICIPALITY_TTL * 100, 2) as RATIO
from SDGS S INNER JOIN PREFECTURE P ON S.PF_CODE=P.PF_CODE
where SURVEY_YEAR = 2022
order by RATIO desc,
CODE asc;