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); ()

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.

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

In SQL, which clause is used to specify a condition for grouping rows?Options HAVINGGROUP BYORDER BYWHERE

Which of the following statements is TRUE about grouping in SQL?You can only group by one column at a time.Grouping automatically sorts the results.You can use aggregate functions directly in the SELECT clause without grouping.Grouping allows you to summarize data based on shared characteristics.

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