SELECT P.PF_CODE AS CODE,
       P.PF_NAME AS NAME,
       ROUND(KEISAN.RATIO, 3) AS RATIO
  FROM PREFECTURE P
  LEFT JOIN (SELECT PF_CODE,
                  round(cast(PROMOTE_MUNICIPALITY as REAL) / cast(MUNICIPALITY_TTL as REAL) * 100, 2) AS RATIO
             FROM SDGS
            WHERE SURVEY_YEAR = '2022') AS KEISAN   
    ON P.PF_CODE = KEISAN.PF_CODE
 ORDER BY RATIO DESC,
          P.PF_CODE