Only object versions that meet the requirements of both query_clauses are selected.
Object versions that meet the requirements of either query_clause are selected.
Only object versions that do not meet the requirements of the query_clause are selected.
The not operator takes precedence over the and operator. The and operator takes precedence over the or operator. Use parentheses in a query to override the existing rules of precedence.