Using Aggregate Functions › Grouping Information › Exercise 5-9

Exercise 5-9

Now You Try It

For statistical purposes, you need to know the number of employees in each department. Enter a SELECT statement to retrieve this information from the EMPLOYEE table.

The result looks like this:

DEPT_ID       (EXPR)
-------       ------
   1100            3
   1110            2
   1120            4
   2200            5
   2210            8
   3510            2
   3520            1
   3530            2
   4500            3
   4600            9
   5000            3
   5100            2
   5200            5
   6200            6

14 rows processed

If your results do not match what you see above, check Review Answers for Chapter 5 for the correct SQL syntax. Remember that result tables may be shortened in this guide.