SELECT
*
FROM (
    SELECT 
    PF_CODE AS CODE
    , PF_NAME AS NAME
    , (PROMOTE_MUNICIPALITY/MUNICIPALITY_TTL)*100 AS RATIO
    FROM PREFECTURE LEFT JOIN SDGS USING (PF_CODE)
    WHERE SURVEY_YEAR = 2022
)
ORDER BY RATIO DESC, CODE ASC