The following SQL statement contains what type of subqueries?
SELECT isbn, title FROM books WHERE pubid =
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS')
AND retail-cost >
(SELECT AVG(retail-cost) FROM books);
If the result returned from a subquery must be compared to a group function, then the inner query
must be nested in the outer query's ____ clause.
The following SQL statement contains which type of subquery?
SELECT title, retail, (SELECT AVG(retail) FROM books)
Which of the following operators is used with a multiple-row subquery?
all of the above
A(n) ____ subquery is one that can return several rows of results.
The ____ operator indicates that the records processed by the outer query must match one of the
values returned by the subquery.
Which operators can be combined with other comparison operators to treat the results of a
subquery as a set of values, rather than as individual values?