correlation name is known to other subqueries at the same level, or to inner queries but not to
outer queries.
If you use the same correlation name at different levels of nesting, an inner query uses the one
from the nearest outer level.
Subquery 295
