sql排序失败

使用排序sql进行分组排序后rank2未能正确排序
SELECT marketing_act_code,marketing_act_type,marketing_act_name,
sum(marketing_amt_used) ,
sum(marketing_amt_budget) ,

rank() over (ORDER by sum(marketing_amt_used) DESC) as rank1,
rank() over (ORDER by sum(marketing_amt_used)/sum(marketing_amt_budget) DESC) as rank2
FROM ads_marketing_effect_d

GROUP BY marketing_act_code

那现在显示的数据什么样啊，正确的应该是怎么样