An EXISTS condition is met if the subquery returns at least one row.
The syntax for EXISTS conditions is as follows:
EXISTS( subquery )
The EXISTS condition is TRUE if the subquery result contains at least one row, and FALSE if the subquery result does not contain any rows. The EXISTS condition cannot be UNKNOWN.