Database: department_store
Question: Return the id of the staff whose Staff Department Assignment was earlier than that of any Clerical Staff.
SQL:
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')