SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.Where, havingHaving, whereGroup by, havingGroup by, where

The clause that applies the aggregate functions to get a single result tuple for each group is known to be

Which T-SQL clause is used with the GROUP BY clause to filter aggregate results?

The GROUP BY clause indicatesthe list of row conditions.the list of row summary conditions.the list of aggregate functions.the list of grouping columns for calculation of aggregate functions.

2. Which PostgreSQL clause is used to perform grouping operations beyond what is specified in the GROUP BY clause? UNION INTERSECT HAVING Grouping sets 8. Which are all possible grouping sets generated by the following statement: SELECT c1, c2, c3, aggregate(c4) FROM table_name GROUP BY ROLLUP (c1, c2, c3)? (c1, c2, c3); (c1, c2); (c2, c3); (c1,c3); (c1); (c2); (c3); () (c1, c2, c3); (c1, c2); (c1,c3); (c1); (c2); (c3); () (c1, c2, c3); (c2, c3); (c1,c3); (c1); (c2); () (c1, c2, c3); (c1, c2); (c1); (c2); () (c1, c2, c3); (c1, c2); (c1); ()