A subquery can consist of a statement located within a clause from a parent statement. Which of the following options apply to a subquery? (MCQ)
Create another SELECT statement in a FROM clause
Create a WHERE statement in an UPDATE clause.
Create another SELECT statement in a HAVING clause.
Create an ALTER statement in a SET clause