Database: department_store
Question: What is id of the staff who had a Staff Department Assignment earlier than 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')