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