subquery in SQL
A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE statement, or inside another subquery. ... A subquery can be used anywhere an expression is allowed. In this example a subquery is used as a column expressio