A simple subquery is a select statement that is contained within an outer select statement. The simple subquery is executed one time and its result is available within the where clause of the outer select.
To learn how to use simple subqueries, follow these steps:
Employeestable. Execute the following SQL select statement: