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.