Using Aggregate Functions › Review

Review

Fill in the blank with the correct term:

1. You use ______ to perform calculations within a SELECT statement.
2. An aggregate function can be used instead of a column name with ______ or in the _______ clause.
3. When the aggregate function AVG encounters a null value, it _______ the row.
4. The _______ clause acts as a search condition with an aggregate function.
5. You rename an aggregate function column heading by using ______ and the heading you want.

To check your answers, see Review Answers for Chapter 5.