select
a.PF_CODE as CODE
,a.PF_NAME as NAME
,ROUND((cast(PROMOTE_MUNICIPALITY as real) / cast(MUNICIPALITY_TTL as real)) * 100,2) as RATIO
from
PREFECTURE a
inner join
SDGS b
on
a.PF_CODE = b.PF_CODE
WHERE
b.SURVEY_YEAR = 2022
order by
RATIO DESC
,CODE ASC
;