Re: Understanding Aliases

> SELECT-list output aliases name the *output* columns of the SELECT.
> Those output columns are not available to the SELECT's computation
> clauses

Then it's unclear how could the first query work