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