SELECT 
S.PF_CODE As CODE,
P.PF_NAME As NAME,
ROUND(100.000*S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL,2) As RATIO
FROM
SDGS S
LEFT OUTER JOIN
PREFECTURE P
ON
S.PF_CODE = P.PF_CODE
WHERE S.SURVEY_YEAR = 2022
ORDER BY 
RATIO DESC,
S.PF_CODE ASC