SELECT S.PF_CODE AS CODE, PF_NAME AS NAME, ROUND(CAST(PROMOTE_MUNICIPALITY AS REAL) / MUNICIPALITY_TTL * 100, 2) AS RATIO
FROM SDGS S JOIN PREFECTURE P ON S.PF_CODE = P.PF_CODE
WHERE SURVEY_YEAR = 2022
ORDER BY RATIO DESC, S.PF_CODE;