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);



Nested SQL Subquery

Explanation:

There are three types of SQL subquery

inline view, Nested Subquery and Scalar Subquery

The Nested SQL Subqueries are queries that appears in the WHERE clause of the SQL statement, as appeared in the above question.

A subquery can be nested inside other subqueries and that is one of the abilities of SQL.

Once this query is placed in the WHERE clause, then it's called a Nested SQL subquery