Using Aggregate Functions › Aggregate Functions › Exercise 5-7

Exercise 5-7

Now You Try It

Also as part of the budget process, the budget group needs to identify all vacation hours taken. (This information is in the BENEFITS table.)

Enter a statement to display this sum.

The result looks like this:

                          (EXPR)
                          ------
                        17469.50

1 row processed

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

Aggregate Functions and Null Values

There may be null values in columns included in a calculation. Aggregate functions ignore rows where a null value is found.