SELECT T1.staff_name FROM staff AS T1 JOIN staff_department_assignments AS T2 ON T1.staff_id  =  T2.staff_id GROUP BY T2.staff_id HAVING COUNT (*)  >  1
What are the names of staff who have been assigned multiple jobs?
SELECT T1.staff_name FROM staff AS T1 JOIN staff_department_assignments AS T2 ON T1.staff_id = T2.staff_id GROUP BY T2.staff_id HAVING COUNT ( * ) > 1
select t1 . staff_name from staff as t1 join staff_department_assignments as t2 on t1 . staff_id = t2 . staff_id group by t2 . staff_id having count ( * ) > value
What are the names of staff who have been assigned multiple jobs ?