Query: invalid sql generated for query with groupby aggregate pushdown projecting constant on top

[maumar]

query using Northwind model:

                var query = ctx.Orders.GroupBy(e => e.CustomerID)
                        .Where(g => g.Count() > 10)
                        .Select(g => g.Key)
                        .OrderBy(t => t)
                        .Take(20)
                        .Skip(4).Select(e => 1);

Query plan:

(QueryContext queryContext) => IEnumerable<int> _InterceptExceptions(
|__ source: IEnumerable<int> _ShapedQuery(
|   |__ queryContext: queryContext, 
|   |__ shaperCommandContext: SelectExpression: 
|   |       SELECT [t].*
|   |       FROM (
|   |           SELECT TOP(@__p_0) [e].*, [e].[CustomerID] AS [Key]
|   |           FROM [Orders] AS [e]
|   |           GROUP BY [e].[CustomerID]
|   |           HAVING COUNT(*) > 10
|   |           ORDER BY [c]
|   |       ) AS [t]
|   |       ORDER BY [t].[Key]
|   |       OFFSET @__p_1 ROWS, 
|   |__ shaper: (QueryContext queryContext | ValueBuffer g) => 1), 
|__ contextType: TestModels.Northwind.NorthwindRelationalContext, 
|__ logger: DiagnosticsLogger<Query>, 
|__ queryContext: Unhandled parameter: queryContext)

exception:

Column 'Orders.OrderID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Invalid column name 'c'.

[smitpatel]

Test: GroupBy_aggregate_Pushdown_followed_by_projecting_constant
Enabled in #16381