Use case
SELECT avg(number) AS number, max(number) FROM numbers(10)

Aggregate function avg(number) is found inside another aggregate function in query.

Possible solutions

1. If aliased expression contains aggregate function, alias should not be resolved inside another aggregate function.
2. If alias name clashes with the column name, the substitution of this alias should be cancelled.