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