What are the staff names and genders for people with job title code Sales Person?
SELECT T1.staff_name , 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   =   "Sales Person"
staff names and genders for people with job title code Sales Person refers to joining staff table with Staff_Department_Assignments table on staff_id and filtering with job_title_code = 'Sales Person';