Checks whether a value exists in a list or subquery result.
Checks whether a subquery returns at least one row.