Chapter 8, Problem 4RQ

Explanation of Solution

Subquery:

• The subquery is a query that is placed inside another SQL query and also embedded inside the “WHERE” clause. It is also called as inner query or nested query.
• The subqueries can be used with the “INSERT”, “SELECT”, “DELETE” and “UPDATE” statements along with the operations such as “=”, “<”, “>”, “<=”, “>=”, “IN”, “BETWEEN”.

Characteristics of subquery:

The basic characteristics of subqueries are:

• The subquery normally expressed inside the parentheses.
• The first statement in the SQL is called as outer query...