Hi

This is a restriction on the group by and having clauses , they cannot use aliased columns.

regards
Hrishy