SELECT
 p.PF_CODE as CODE
 ,PF_NAME as NAME
 ,ROUND((CAST(PROMOTE_MUNICIPALITY as REAL) / CAST(MUNICIPALITY_TTL as REAL))*100,2) as RATIO
FROM
 PREFECTURE p
 inner join SDGS s
 on p.PF_CODE = s.PF_CODE
WHERE
 SURVEY_YEAR = 2022
 and PROMOTE_MUNICIPALITY IS NOT NULL
 and MUNICIPALITY_TTL IS NOT NULL
ORDER BY
 RATIO desc
 ,p.PF_CODE