Chapter 7. Subqueries
A subquery is a SELECT statement nested in various clauses of a SQL statement. It allows you to use the output from one query as the input of another SQL statement. Subqueries make it easy to break down problems into logical and manageable pieces.
Lab 7.1 Simple Subqueries
As mentioned, a subquery allows you to break down a problem into individual components and solve it ...