SELECT
    PF.PF_CODE as CODE,
    PF.PF_NAME as NAME,
    ROUND(CAST(SD.PROMOTE_MUNICIPALITY as REAL) / CAST(SD.MUNICIPALITY_TTL as REAL)*100,3) as RATIO
FROM
    PREFECTURE PF
INNER JOIN
    SDGS SD
ON
    PF.PF_CODE = SD.PF_CODE
WHERE
    SURVEY_YEAR = 2022
ORDER BY
    RATIO desc,
    PF.PF_CODE asc
;