Task: Text to Code
Input (English): Step 1: For each row in Staff_Department_Assignments table, find corresponding rows in Staff table and in Departments table.
Step 2: find Staff's staff_id, staff_gender of the results of step 1 whose department_name equals Department Manager
Output (English): SELECT T1.staff_id , T1.staff_gender FROM Staff AS T1 JOIN Departments AS T2 JOIN Staff_Department_Assignments AS T3 ON T1.staff_id = T3.staff_id AND T3.department_id = T2.department_id WHERE T2.department_name = "Department Manager"