medium · ~8 min
Resource Management needs a list of bench employees who are currently not assigned to any project.
employees
projects
emp_id
name
department
Input contract: emp_id is the non-null primary key of employees; name and department are non-null. In projects, project_id is the non-null primary key and emp_id is a non-null foreign key referencing employees (an employee may appear on zero, one, or many projects).
project_id