SELECT p.PF_CODE AS CODE, PF_NAME AS NAME, ROUND(100.0*PROMOTE_MUNICIPALITY/MUNICIPALITY_TTL, 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;