here is a sample example,
Complex expressions can be built by combining expressions with the AND and OR operators.
For example, the following expression would select all the houses
that have more than 1,500 square feet and a garage for three or more
"AREA" > 1500 AND "GARAGE" > 3
When you use the OR operator, at least one side of the expression of
the two separated by the OR operator must be true for the record to be
"RAINFALL" < 20 OR "SLOPE" > 35
Use the NOT operator at the beginning of an expression to find features or records that don't match the specified expression.
NOT "STATE_NAME" = 'Colorado'
NOT expressions can be combined with AND and OR.
For example, this expression would select all the New England states except Maine:
"SUB_REGION" = 'New England' AND NOT "STATE_NAME" = 'Maine'
Hope it helps you.