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

How many aggregate functions are in SQL?1 point6534

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

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

_______ will perform summary operations on a set of values to result an single value.Select one:a.Date functionsb.Single row functionsc.Aggregate functionsd.Numeric functions

.Question 12How many aggregate functions are in SQL?0 / 1 point6534