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