SELECT
        PRE.PF_CODE AS CODE
       ,PRE.PF_NAME AS NAME
       ,ROUND((CAST(S.PROMOTE_MUNICIPALITY as REAL) / CAST(S.MUNICIPALITY_TTL as REAL) * 100), 2) AS RATIO
    FROM
        PREFECTURE PRE
       ,SDGS       S
    WHERE
        S.SURVEY_YEAR = 2022
    AND S.PF_CODE = PRE.PF_CODE
    ORDER BY
        RATIO DESC
       ,CODE  ASC