Using Aggregate Functions › Eliminating Duplicate Rows › Exercise 5-8

Exercise 5-8

Now You Try It

Count the number of different projects on which at least one person is working.

What table do you need to use?

You'll find this information in the CONSULTANT table.

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.