SELECT 
  SD.PF_CODE AS CODE, 
  PF.PF_NAME AS NAME, 
  ROUND((PROMOTE_MUNICIPALITY * 100.0 / MUNICIPALITY_TTL), 2) AS RATIO
FROM 
  SDGS SD
INNER JOIN PREFECTURE AS PF 
ON PF.PF_CODE = SD.PF_CODE 
WHERE 
  SD.SURVEY_YEAR = 2022  -- 調査年が2022年のデータのみ
ORDER BY 
  RATIO DESC,  -- 割合の降順
  SD.PF_CODE ASC; -- 都道府県コードの昇順