The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

SELECT dept_name , ID , avg ( salary ) FROM instructor GROUP BY dept_name; This statement IS erroneous because

SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

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.

Which of the following creates a temporary relation for the query on which it is defined?

WITH max_budget ( VALUE ) AS ( SELECT MAX ( budget ) FROM department ) SELECT budget FROM department , max_budget WHERE department . budget = MAX budget . value; In the query given above which one of the following is a temporary relation?