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