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

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

How many aggregate functions are in SQL?1 point6534

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

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

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