SELECT S.PF_CODE AS CODE,
P.PF_NAME AS NAME,
ROUND(CAST(S.PROMOTE_MUNICIPALITY AS REAL)/S.MUNICIPALITY_TTL*100,2) 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,S.PF_CODE ASC;