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,3) AS RATIO

FROM
SDGS S
INNER JOIN PREFECTURE P
ON S.PF_CODE = P.PF_CODE

WHERE
S.SURVEY_YEAR = 2022

--GROUP BY S.PF_CODE

ORDER BY
RATIO ASC,
S.PF_CODE ASC;