Which of the following statements is true?
A.
“IN cannot be used with the <, > or = operators for correlated subqueries.”
B.
“IN cannot be used with correlated subqueries.”
C.
“IN can only be used with the = operator for correlated subqueries.”
D.
“IN can only be used with the < and > operators for scalar subqueries.”