Task: Text to Code
Input (English): Step 1: find the staff_id of Staff_Department_Assignments table.
Step 2: find the staff_name, staff_gender of Staff table whose Staff's staff_id not one of the results of step 1
Output (English): SELECT T1.staff_name , T1.staff_gender FROM Staff AS T1 WHERE T1.staff_id NOT IN ( SELECT T2.staff_id FROM Staff_Department_Assignments AS T2 )