A nested query in the FROM clause is necessary to compute nested aggregate calculations because the SELECT statement does not allow an aggregate function inside an aggregate function.1 pointTrueFals

Question 14Indicate reasons for using a nested query in the FROM clause. Multiple answers are possible.1 pointto compute a nested aggregate function, an aggregate function within an aggregate function.to compute independent aggregate functions involving different tablesto demonstrate query formulation ability to colleaguesto simplify some complex decision making queries involving many tables and aggregate functions

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

How many aggregate functions are in SQL?1 point6534

The clause that applies the aggregate functions to get a single result tuple for each group is known to be

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