Re-use of an alias name in a peer or child context within complex queries can make it difficult to follow what is happening in a query. Although it is allowed by the language due to scoping rules, this practice should be discouraged. Give examples of both peer and child contexts re-using an alias name to illustrate the anti-pattern.