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