You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? ()
- A The main query executes with the first value returned by the subquery.
- B The main query executes with the last value returned by the subquery.
- C The main query executes with all the values returned by the subquery.
- D The main query fails because the multiple-row subquery cannot be used with the comparison operator.
- E You cannot define a multiple-row subquery in the WHERE clause of a SQL query.