Question

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

I got this question by my college professor while I was bunking the class.

This question is from Aggregate Functions and Nested Subqueries in portion SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right choice is (b) With

Easy 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.