Which department has more employees than department 20?

Question

Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)

Answer 1

```
SQL> SELECT DeptId, COUNT(*)
2 FROM employee
3 GROUP BY DeptId
4 HAVING COUNT(*) >
5 (SELECT COUNT(*)
6 FROM employee
7 WHERE DeptId = 20);

DEPTID COUNT(*)
---------- ----------
10 3
```