Select the names of departments with more than two employees.
| SELECT ssn, department FROM employees
| GROUP department, ssn COUNT BY department
| WHERE ssn-count > 2
| PROJECT department
| SELECT code, name FROM departments WHERE code
| RENAME code department
| JOIN department
| GROUP name BY name
2 rows 1 msec
| GROUP department, ssn COUNT BY department
| WHERE ssn-count > 2
| PROJECT department
| SELECT code, name FROM departments WHERE code
| RENAME code department
| JOIN department
| GROUP name BY name
2 rows 1 msec
name |
---|
Human Resources |
IT |