Employee management exercise 13

Back to Employee management

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
name
Human Resources
IT