Fix subquery planning having an aggregation that is used in order by as long as we can merge it all into a single route

Fix subquery planning having an aggregation that is used in order by as long as we can merge it all into a single route #24398