The query clauses can be any legal query (including another "and"). At least one clause must be specified, and all the clauses must be true for the "and" clause to be true. An "or" operator is also ...