hi,
here is a sample example,
Combining expressions:-
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
cars:
"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
selected.
For example:
"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.
For example:
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.