Which statement is true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three )