SELECT 
 S.PF_CODE as CODE,
 P.PF_NAME as NAME,
 ROUND((S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL * 100),3) as RATIO
FROM SDGS as S
INNER JOIN PREFECTURE as P
ON P.PF_CODE = S.PF_CODE
WHERE
 S.SURVEY_YEAR = 2022
ORDER BY 
 RATIO DESC,
 P.PF_CODE ASC;