What is the purpose of the PARTITION BY clause in an aggregate function using windows in SQL?Review LaterTo group the result set into categoriesTo specify the column on which the calculation should be performedTo specify the window over which the calculation should be performedTo perform the calculation on a subset of the result set

Question 5: (1.00) If you skip the PARTITION BY clause, the window function will… treat the whole result set as a single partition divide rows into multiple groups specify the order of rows in each partition define a subset of rows in the current partition

Consider this SQL statement:SELECT product, prod_cost, avg(prod_cost) OVER (PARTITION BY product)FROM product_detailThe OVER clause makes this what type of function?Aggregate functionSystem functionWindow functionUser-defined function

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.

What is the purpose of the SQL GROUP BY clause?OptionsTo filter rows from a tableTo group rows with the same values into summary rowsTo join two or more tablesTo sort rows in a table