BETWEEN: checks whether attribute value is within a range
IS null checks whether attribute value is null
LIKE: checks whether attribute value matches given string pattern
IN: checks whether attribute value matches any value within a value list
EXISTS: checks if subquery returns any rows