I didn’t know one could still refer to the value before aggregation after it is aliased.

Is there an implicit group by in this query?