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