What is the role of a subquery inside a WHERE clause?
WHERE
Its result supplies a value or set of values used to filter rows from the outer query.
It always creates a new permanent table.
It only changes the display names of outer columns.
It commits all pending database changes.