SELECT
    PF_CODE AS CODE,
    PF_NAME AS NAME,
    RATIO
FROM
(
SELECT
    *
FROM
(
SELECT
    PF_CODE,
    ROUND(CAST(CAST(PROMOTE_MUNICIPALITY AS REAL) / CAST(MUNICIPALITY_TTL AS REAL) AS REAL)*100,3)  AS RATIO
FROM
    SDGS
WHERE
    SURVEY_YEAR = "2022"
) AS T001
    INNER JOIN PREFECTURE AS T002
    ON T001.PF_CODE = T002.PF_CODE
)
ORDER BY RATIO DESC , NAME
;