Previous Topic: Aggregate FunctionsNext Topic: Exercise 5-2

Using Aggregate Functions › Aggregate Functions › Exercise 5-1

Exercise 5-1

Now You Try It

Use the COVERAGE table to write a SELECT statement to display the average number of dependents for all employees in Commonwealth Auto. The Human Resources department needs this information for statistical purposes.

The result looks like this:

                          (EXPR)
                          ------
                               1

1 row processed

If your results do not match what you see above, check Review Answers for Chapter 5 for the correct SQL syntax.

Note: If the column being averaged has an integer data type, the result is an integer (that is, a whole number). Refer to the SQL reference manual for your environment to learn how to convert an integer data type to a decimal data type in the result of your query.