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