SELECT
s.PF_CODE AS 'CODE'
,p.PF_NAME AS 'NAME'
,ROUND(cast(PROMOTE_MUNICIPALITY as REAL)/cast(MUNICIPALITY_TTL as REAL)*100,2) AS 'RATIO'
FROM
SDGS s
INNER JOIN
PREFECTURE p
ON
s.PF_CODE = p.PF_CODE
WHERE
SURVEY_YEAR = 2022
ORDER BY
RATIO desc
,s.PF_CODE asc
;