WITH SRAITO AS(
    SELECT PF_CODE, PROMOTE_MUNICIPALITY / MUNICIPALITY_TTL * 100 AS RAITO
    FROM SDGS
    WHERE S.SURVEY_YEAR = 2022
    GROUP BY PF_CODE
    )

SELECT
    P.PF_CODE AS CODE
    ,P.PF_NAME AS NAME
    ,ROUND(SR.RAITO, 2) AS RATIO
FROM
    PREFECTURE P INNER JOIN SDGS S
    ON P.PF_CODE = S.PF_CODE
    INNER JOIN SRAITO SR
    ON S.PF_CODE = SR.PF_CODE
WHERE
    S.SURVEY_YEAR = 2022
GROUP BY
    P.PF_CODE, P.PF_NAME
ORDER BY
    RATIO DESC
    ,P.PF_CODE