Explanation:Aggregate functions perform a calculation on a set of values. 2. SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.
A. Group by
B. With
C. Where
D. Having
Answer:A
Explanation:Aggregate functions perform a calculation on a set of values. 2. SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.
A. Group by B. With C. Where D. Having
Explanation:The with clause provides away of defining a temporary relation whose definition is available only to the query in which the with clause occurs.