Query: invalid sql for query with group by with First and OrderBy afterwards

[maumar]

query:

                var query = ctx.Employees.Where(e => e.EmployeeID == 1)
                            .GroupBy(e => e.EmployeeID)
                            .Select(g => EF.Property<string>(g.First(), "Title"))
                            .OrderBy(e => e);

                var result = query.ToList();

sql:

SELECT [e].[Title]
FROM [Employees] AS [e]
WHERE [e].[EmployeeID] = 1
GROUP BY [e].[EmployeeID]
ORDER BY [e].[Title]

error:
Column 'Employees.Title' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

[smitpatel]

Related #12089

[smitpatel]

Merged into #13805