SELECT staff_id FROM Staff_Department_Assignments WHERE date_assigned_to  <  (SELECT max(date_assigned_to) FROM Staff_Department_Assignments WHERE job_title_code  =  'Clerical Staff')
Return the id of the staff whose Staff Department Assignment was earlier than that of any Clerical Staff.
SELECT staff_id FROM Staff_Department_Assignments WHERE date_assigned_to < ( SELECT max ( date_assigned_to ) FROM Staff_Department_Assignments WHERE job_title_code = 'Clerical Staff ' )
select staff_id from staff_department_assignments where date_assigned_to < ( select max ( date_assigned_to ) from staff_department_assignments where job_title_code = value )
Return the id of the staff whose Staff Department Assignment was earlier than that of any Clerical Staff .