Even when there is no repetition of SQL, the WITH clause can simplify complex queries, like the following example that lists those departments with above average wages.A with expression produces a copy of its operand with the specified properties and fields modified. You use the object initializer syntax to specify what members to modify and their