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,2) 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 DESC,
S.PF_CODE ASC;