The Following SQL Statement Contains Which Type of Subquery

question 57

Multiple Choice

The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail) FROM books
GROUP BY category) ;

• A) ​single-row
• B) ​multiple-row
• C) ​multiple-column
• D) ​correlated