Using Where
clause after OrderBy
clause requires the whole collection to be sorted and then filtered.
Where
should be called first to sort only the filtered items.
enumerable.Where(...).OrderBy(...) // compliant
enumerable.OrderBy(...).Where(...) // non-compliant