SELECT
    S.pf_code AS CODE
    , P.pf_name AS NAME
    , ROUND( 
        100.0 * S.promote_municipality / S.municipality_ttl
        , 2
    ) AS RATIO 
FROM
    sdgs S 
    INNER JOIN prefecture P 
        ON S.pf_code = P.pf_code 
WHERE
    S.survey_year = 2022 
ORDER BY
    ratio DESC
    , S.pf_code ASC