Database: department_store
Question: Return the staff ids and genders for any staff with the title Department Manager.
SQL:
SELECT T1.staff_id ,  T1.staff_gender FROM staff AS T1 JOIN staff_department_assignments AS T2 ON T1.staff_id  =  T2.staff_id WHERE T2.job_title_code  =  "Department Manager"