The following SQL statement contains what type of subquery? SELECT b.title, b.retail, a.category, a.cataverage
FROM books b, (SELECT category, AVG(retail) cataverage
FROM books GROUP BY category) a
A) single-row subquery
B) multiple-row subquery
C) inline view
D) none of the above

Question

Quizplus · Accepted Answer

The subquery "(SELECT category, AVG(retail) cataverage FROM books GROUP BY category)" creates an inline view that is then joined with the "books" table in the outer query. Therefore, this is an example of an inline view subquery.

The Following SQL Statement Contains What Type of Subquery? SELECT