Which of the following operators could be used to unnest the following SQL query? Select ALL that applies.

SELECT CustomerName

FROM Customers

WHERE CustomerID IN $($SELECT CustomerID FROM Orders$)$;

Group of answer choices

Semi$-$Join

Cartesian Product Join

Union

Set Difference

Projection there can be multiple answers