SELECT
PF_CODE AS CODE,
PF_NAME AS NAME,
ROUND(CAST(PROMOTE_MUNICIPALITY AS REAL)/MUNICIPALITY_TTL * 100.00,2) AS RATIO
FROM
(SELECT *
FROM
SDGS t1
LEFT JOIN
PREFECTURE t2
ON
t1.PF_CODE = t2.PF_CODE
)
WHERE
SURVEY_YEAR = 2022
ORDER BY
RATIO DESC,
PF_CODE;