How to Work with Subqueries in SQL
Whenever you see a query nested inside another query in SQL, that’s a subquery. A subquery is also known as an inner query while the one that contains it is called the main or outer query. Subqueries
Fuente: Artículo original