Nested subqueries

A nested subquery is a subquery nested within another subquery. There is no limit to the level of subquery nesting you can define, however,
queries with three or more levels take considerably longer to run than do smaller queries.

The following example uses nested subqueries to determine the order IDs and line IDs of those orders shipped on the same day
when any item in the fees department was ordered.