Previous Topic: Using HAVINGNext Topic: Exercise 5-12

Using Aggregate Functions › Using HAVING › Exercise 5-11

Exercise 5-11

Now You Try It

Some Commonwealth Auto employees live in the same community. Since the company is encouraging car pooling, the car pooling group needs to know which communities have more than two people living there.

Enter a SELECT statement to list the name of the community and the number of employees living in that community. Show only those communities that have more than two employees. This information is contained in the EMPLOYEE table.

The result looks like this:

CITY                       (EXPR)
----                       ------
Boston                          6
Brookline                      11
Camden                          3
Canton                          4
Grover                          4
Medford                         9
Natick                          5
Newton                          4
Wilmington                      3

9 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.