Explanation:Any attribute that is not present in the group by clause must appear only inside an aggregate function if it appears in the select clause, otherwise the query is treated as erroneous. 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:Any attribute that is not present in the group by clause must appear only inside an aggregate function if it appears in the select clause, otherwise the query is treated as erroneous. 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.. 3. 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.