Question 4: (1.00) PostgreSQL evaluates the GROUP BY clause after.. the FROM and WHERE clauses the HAVING clause the ORDER BY clause the Select clause the LIMIT clause

Question 7: (1.00) When you use the GROUP BY clause without applying an aggregate function, it works like… the LIMIT clause the HAVING clause the DISTINCT clause the ORDER BY clause the JOIN clause

Which of the following clause is the last clause in the select statement?Select one:Group ByWhereOrder ByHaving

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

Question 6Fill in the blank: A SQL clause containing HAVING allows you to add a filter to your query when working with _____ functions.1 pointORDER BYGROUP BYaggregatejoin

elect the correct answerWhat is the order of statements in the select statement ?OptionsSELECT FROM WHERE GROUP BY ORDER BY HAVINGSELECT FROM WHERE GROUP BY HAVING ORDER BYNone of theseSELECT WHERE FROM GROUP BY HAVING ORDER BYSELECT FROM GROUP BY WHERE HAVING ORDER BY