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.
A. Where, having
B. Having, where
C. Group by, having
D. Group by, where
Answer:A
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.
A. Where, having B. Having, where C. Group by, having D. Group by, where
Explanation:To include aggregate functions having clause must be included after where. 4. The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.