SELECT
    logs.PF_CODE AS CODE,
    PF_NAME AS NAME,
    logs.RATIO
FROM (
    SELECT
        PF_CODE,
        ROUND(CAST(SUM(PROMOTE_MUNICIPALITY) * 100 AS FLOAT64) / CAST(MUNICIPALITY_TTL AS FLOAT64), 2) AS RATIO
    FROM
        SDGS
    WHERE
        SURVEY_YEAR = 2022
    GROUP BY
        PF_CODE
) AS logs
LEFT OUTER JOIN
    PREFECTURE
ON
    logs.PF_CODE = PREFECTURE.PF_CODE
ORDER BY
    RATIO DESC,
    CODE ASC