easy · ~6 min
Finance Operations needs a roster of employees working in Engineering, Marketing, or Finance for quarterly budget planning.
employees
department
'Engineering'
'Marketing'
'Finance'
name
salary
Input contract: emp_id is the non-null primary key of employees; name and salary are non-null; department may be NULL for unassigned staff (who should not be included in this roster).
emp_id
NULL