select s.PF_CODE as 'CODE',p.PF_NAME as 'NAME',round(cast(s.PROMOTE_MUNICIPALITY as float)/s.MUNICIPALITY_TTL*100,2) as 'RATIO'
from SDGS s
inner join PREFECTURE p on s.PF_CODE  = p.PF_CODE
where s.SURVEY_YEAR = '2022'
order by round(cast(s.PROMOTE_MUNICIPALITY as float)/s.MUNICIPALITY_TTL*100,2) desc,p.PF_CODE;