Only object versions that meet the requirements of both of the query_clause operators 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.