[FEATURE] Support push down sort on metrics for aggregation with more than one agg call

[qianheng-aws]

Is your feature request related to a problem?
After #4603, we support push down aggregation metrics sort while it only supports when there is only 1 agg call in the aggregation. That optimization could be extended to support aggregation more than 1 agg call and the metric sort upon it has only one collation field.

e.g. clickbench q10:

source=hits
| stats bucket_nullable=false sum(AdvEngineID), count() as c, avg(ResolutionWidth), dc(UserID) by RegionID
| sort - c
| head 10

What solution would you like?
A clear and concise description of what you want to happen.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.