CREATE TABLE staff (staff_id VARCHAR2, staff_gender VARCHAR2)
CREATE TABLE staff_department_assignments (staff_id VARCHAR2, job_title_code VARCHAR2)

What are the staff ids and genders of all staffs whose job title is Department Manager?
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"
SELECT "T1"."staff_id", "T1"."staff_gender" FROM "staff" "T1" JOIN "staff_department_assignments" "T2" ON "Department Manager" = "T2"."job_title_code" AND "T1"."staff_id" = "T2"."staff_id"