added support for having clause in global aggregate
and group by