>=, =>: Left-hand expression is greater than or equal to right-hand expression
<=, =<: Left-hand expression is less than or equal to right-hand expression
>: Left-hand expression is greater than right-hand expression
<: Left-hand expression is less than right-hand expression
!=, <>: Left-hand expression is not equal to right-hand expression
BETWEEN: Left-hand expression is between or equal to either of the values in the right-hand expression, which specifies lower and upper bounds - ex: BETWEEN { 0, 5 }
Predicate Compound Operators
AND, &&: Logical AND
OR, ||: Logical OR
NOT, !: Logical NOT
Predicate String Comparison Operators
BEGINSWITH: Left-hand expression begins with right-hand expression
ENDSWITH: Left-hand expression ends with right-hand expression