Answer:
A subquery is, as the name suggests, a query within another query. The outer query is called the main query, while the inner query is the subquery. You can think of this in terms of composition of functions. A subquery is always executed first, and its result is then passed on to the main query.
| Previous Question | Next Question |
| Tell me how often should you retrain a data model? | Explain me what is self JOIN? |