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.

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

What does the GROUP BY statement do in SQL?Groups rows that have the same values in specified columns into aggregated dataGroups tables that have the same columnsGroups database users that have the same privilegesNone of the above

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

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

What happens if you omit the GROUP BY clause in a SQL query with aggregate functions?a.The query returns the aggregate result for the entire tableb.The query returns an errorc.The query returns only the first row of the result setd.The query groups all rows into a single group