Query: invalid SQL generated when doing join with nested anonymous key selectors

[maumar]

query:

    [ConditionalTheory]
    [MemberData(nameof(IsAsyncData))]
    public virtual Task Join_with_key_selectors_being_nested_anonymous_objects(bool async)
        => AssertQuery(
            async,
            ss => ss.Set<Customer>().Order().Take(10).Join(
                ss.Set<Order>(),
                x => new { x.CustomerID, Nested = new { x.City, Year = 1996 } },
                x => new { x.CustomerID, Nested = new { City = "London", x.OrderDate.Value.Year } },
                (c, o) => new { c, o }),
            elementSorter: e => (e.c.CustomerID, e.o.OrderID ),
            elementAsserter: (e, a) =>
            {
                AssertEqual(e.c, a.c);
                AssertEqual(e.o, a.o);
            });

sql:

SELECT [c0].[CustomerID], [c0].[Address], [c0].[City], [c0].[CompanyName], [c0].[ContactName], [c0].[ContactTitle], [c0].[Country], [c0].[Fax], [c0].[Phone], [c0].[PostalCode], [c0].[Region], [o].[OrderID], [o].[CustomerID], [o].[EmployeeID], [o].[OrderDate]
FROM (
    SELECT TOP(@__p_0) [c].[CustomerID], [c].[Address], [c].[City], [c].[CompanyName], [c].[ContactName], [c].[ContactTitle], [c].[Country], [c].[Fax], [c].[Phone], [c].[PostalCode], [c].[Region]
    FROM [Customers] AS [c]
    ORDER BY [c].[CustomerID]
) AS [c0]
INNER JOIN [Orders] AS [o] ON [c0].[CustomerID] = [o].[CustomerID] AND -- <-- error here
ORDER BY [c0].[CustomerID]

error:
Microsoft.Data.SqlClient.SqlException : Incorrect syntax near the keyword 'ORDER'.

[maumar]

somewhat related to #35038