Subquery predicates

Subquery under an IN predicate.
Subquery under an ANY predicate.
Subquery under an ALL predicate.
Subquery under an EXISTS predicate.
Subquery under an EXPRESSION predicate.

Subqueries introduced by in, any, all, or exists are quantified predicate subqueries. Subqueries introduced by >, >=, <, <=, =, != are expression subqueries.