Unlike in relational, orderings aren't lifted to the outer on subquery pushdown. So we'll need to manually lift them for this case and reverse them.