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