select * from
(
select 
S.PF_CODE as CODE,
P.PF_NAME as NAME,
round(PROMOTE_MUNICIPALITY *1.0 /MUNICIPALITY_TTL*1.0 *100*1.0,2)  as RATIO
--,PROMOTE_MUNICIPALITY,MUNICIPALITY_TTL
from SDGS S
left join PREFECTURE P ON S.PF_CODE= P.PF_CODE
where SURVEY_YEAR='2022'
)A
order by 
RATIO desc,
CODE asc