The IN operator indicates that the records processed by the outer query must match one of the values returned by the sub-query.
The IN operator allows the specification of a collection of expressions (or constants) that are subsequently used for the query search. This operator is applied to a sub-query for the identical reason that's, when the results of an inner query contains a collection of values.
The IN operator in sub-query allows to specifies multiple values in WHERE clause, it can facilitate your to simply test if an expression matches any value within the list of values. the utilization of IN operator reduces the necessity for multiple or conditions in statements.
To know more about sub-query here
brainly.com/question/14079843
#SPJ4
