A subquery is a query within another SQL query. A subquery is also called inner query or inner select and the statement containing a subquery is called an outer query or outer select.
Note
Subqueries must be enclosed within parenthesis,
An ORDER BY cannot be used in a subquery.
The image type ...
