Subquery

A subquery is a query nested inside another query. The inner query runs first, and its result is used by the outer query — for example, to filter on a…