Stream Aggregate only requires its input to be sorted by the GROUP BY keys. For a scalar aggregate (no GROUP BY clause) no ordering is required.